DBA Data[Home] [Help]

APPS.POS_SPM_WF_PKG1 dependencies on FND_USER_RESP_GROUPS_DIRECT

Line 1996: fnd_user_resp_groups_direct furg,

1992: CURSOR l_receiver_cur IS
1993: select DISTINCT fu.user_name
1994: from fnd_user fu,
1995: fnd_responsibility fr,
1996: fnd_user_resp_groups_direct furg,
1997: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua
1998: where fr.menu_id IN
1999: (SELECT fme.menu_id
2000: FROM fnd_menu_entries fme

Line 2125: fnd_user_resp_groups_direct furg,

2121: --
2122: OPEN x_refcur FOR
2123: select DISTINCT psuv.user_name
2124: from fnd_responsibility fr,
2125: fnd_user_resp_groups_direct furg,
2126: pos_supplier_users_v psuv
2127: where fr.menu_id IN
2128: (SELECT fme.menu_id
2129: FROM fnd_menu_entries fme