DBA Data[Home] [Help]

APPS.EGO_SECURITY_PUB dependencies on FND_USER

Line 21: -- fnd_user users,

17: -- CURSOR check_override_function(cp_party_id NUMBER)
18: -- IS
19: -- SELECT 'X'
20: -- FROM fnd_form_functions functions,
21: -- fnd_user users,
22: -- fnd_menu_entries role_privileges,
23: -- fnd_responsibility resp,
24: -- fnd_user_resp_groups user_resps
25: -- WHERE users.customer_id=cp_party_id

Line 24: -- fnd_user_resp_groups user_resps

20: -- FROM fnd_form_functions functions,
21: -- fnd_user users,
22: -- fnd_menu_entries role_privileges,
23: -- fnd_responsibility resp,
24: -- fnd_user_resp_groups user_resps
25: -- WHERE users.customer_id=cp_party_id
26: -- AND user_resps.start_date<= sysdate
27: -- AND nvl( user_resps.end_date,sysdate+1 ) >= sysdate
28: -- AND users.user_id=user_resps.user_id

Line 672: FROM fnd_user

668:
669:
670: CURSOR get_party_id(cp_user_id NUMBER) IS
671: SELECT nvl(customer_id , person_party_id) -- for bug 11776762
672: FROM fnd_user
673: WHERE user_id=cp_user_id;
674:
675: BEGIN
676:

Line 810: FROM fnd_user

806:
807:
808: CURSOR get_party_id(cp_user_id NUMBER) IS
809: SELECT nvl(customer_id , person_party_id) -- for bug 11776762
810: FROM fnd_user
811: WHERE user_id=cp_user_id;
812: BEGIN
813:
814: OPEN get_party_id (cp_user_id => p_user_id);

Line 1105: FROM fnd_user

1101: -- END OF comments
1102: l_party_id NUMBER;
1103: CURSOR get_party_id(cp_user_id NUMBER) IS
1104: SELECT nvl(customer_id , person_party_id) -- for bug 11776762
1105: FROM fnd_user
1106: WHERE user_id=cp_user_id;
1107:
1108: BEGIN
1109: