Discoverer Documentor and Dashboards

Business Area security details

Business Area security details

SELECT DISTINCT decode(o100572.ap_priv_level, 1, 'Yes', 'No') administration_allowed,
decode(EUL5_get_isitapps_eul, 1, decode(o100591.eu_role_flag, 1, EUL5_get_apps_userresp(o100591.eu_username, 'R'), EUL5_get_apps_userresp(o100591.eu_username)), o100591.eu_username) user_role_responsibility
FROM EUL5_bas o100577,
EUL5_ba_obj_links o100582,
EUL5_access_privs o100572,
EUL5_eul_users o100591
WHERE((o100577.ba_id = o100582.bol_ba_id)
and ( o100577.ba_id = 100036 or lower(o100577.ba_name) like lower('HRMS - Compensation and Benefits (Participant)') )
AND(o100591.eu_id(+) = o100572.ap_eu_id)
AND(o100577.ba_id = o100572.gba_ba_id))
AND(o100572.gba_ba_id IS NOT NULL)