DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on FND_USER_RESP_GROUPS

Line 672: from fnd_user fu, fnd_responsibility fr, fnd_user_resp_groups furg

668: -- added Resposibility-User active date check (furg active date check) as per bug 3464424 fix */
669: CURSOR C_RESPS IS
670: select fr.responsibility_key, fr.responsibility_id, fr.application_id,
671: fr.menu_id
672: from fnd_user fu, fnd_responsibility fr, fnd_user_resp_groups furg
673: where fu.user_id = p_user_id
674: and furg.user_id = fu.user_id
675: and fr.responsibility_id = furg.responsibility_id
676: and fr.application_id = furg.responsibility_application_id

Line 719: from fnd_user fu, fnd_responsibility fr, fnd_user_resp_groups furg, org_access_view oav

715:
716: CURSOR C_RESPS IS
717: select fr.responsibility_key, fr.responsibility_id, fr.application_id,
718: fr.menu_id
719: from fnd_user fu, fnd_responsibility fr, fnd_user_resp_groups furg, org_access_view oav
720: where fu.user_id = p_user_id
721: and furg.user_id = fu.user_id
722: and fr.responsibility_id = furg.responsibility_id
723: and fr.application_id = furg.responsibility_application_id