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 617: FROM fnd_user

613:
614:
615: CURSOR get_party_id(cp_user_id NUMBER) IS
616: SELECT customer_id
617: FROM fnd_user
618: WHERE user_id=cp_user_id;
619:
620: BEGIN
621:

Line 755: FROM fnd_user

751:
752:
753: CURSOR get_party_id(cp_user_id NUMBER) IS
754: SELECT customer_id
755: FROM fnd_user
756: WHERE user_id=cp_user_id;
757: BEGIN
758:
759: OPEN get_party_id (cp_user_id => p_user_id);

Line 1050: FROM fnd_user

1046: -- END OF comments
1047: l_party_id NUMBER;
1048: CURSOR get_party_id(cp_user_id NUMBER) IS
1049: SELECT customer_id
1050: FROM fnd_user
1051: WHERE user_id=cp_user_id;
1052:
1053: BEGIN
1054: