DBA Data[Home] [Help]

APPS.POS_SPM_WF_PKG1 dependencies on FND_USER_RESP_GROUPS_DIRECT

Line 1928: fnd_user_resp_groups_direct furg,

1924: CURSOR l_receiver_cur IS
1925: select DISTINCT fu.user_name
1926: from fnd_user fu,
1927: fnd_responsibility fr,
1928: fnd_user_resp_groups_direct furg,
1929: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua
1930: where fr.menu_id IN
1931: (SELECT fme.menu_id
1932: FROM fnd_menu_entries fme

Line 2057: fnd_user_resp_groups_direct furg,

2053: --
2054: OPEN x_refcur FOR
2055: select DISTINCT psuv.user_name
2056: from fnd_responsibility fr,
2057: fnd_user_resp_groups_direct furg,
2058: pos_supplier_users_v psuv
2059: where fr.menu_id IN
2060: (SELECT fme.menu_id
2061: FROM fnd_menu_entries fme