DBA Data[Home] [Help]

APPS.FUN_REPORT_PVT dependencies on PER_ALL_PEOPLE_F

Line 45: PER_ALL_PEOPLE_F PAP,

41: SELECT distinct(HZP.party_id)
42: INTO l_person_id
43: FROM HZ_PARTIES HZP,
44: FND_USER U,
45: PER_ALL_PEOPLE_F PAP,
46: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
47: WHERE CURR.user_id = U.user_id
48: AND U.employee_id = PAP.person_id
49: AND PAP.party_id = HZP.party_id;

Line 316: PER_ALL_PEOPLE_F PAP,

312: SELECT distinct(HZP.party_id)
313: INTO l_person_id
314: FROM HZ_PARTIES HZP,
315: FND_USER U,
316: PER_ALL_PEOPLE_F PAP,
317: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
318: WHERE CURR.user_id = U.user_id
319: AND U.employee_id = PAP.person_id
320: AND PAP.party_id = HZP.party_id;

Line 708: PER_ALL_PEOPLE_F PAP,

704: SELECT distinct(HZP.party_id)
705: INTO l_person_id
706: FROM HZ_PARTIES HZP,
707: FND_USER U,
708: PER_ALL_PEOPLE_F PAP,
709: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
710: WHERE CURR.user_id = U.user_id
711: AND U.employee_id = PAP.person_id
712: AND PAP.party_id = HZP.party_id;

Line 963: PER_ALL_PEOPLE_F PAP,

959: SELECT distinct(HZP.party_id)
960: INTO l_person_id
961: FROM HZ_PARTIES HZP,
962: FND_USER U,
963: PER_ALL_PEOPLE_F PAP,
964: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR
965: WHERE CURR.user_id = U.user_id
966: AND U.employee_id = PAP.person_id
967: AND PAP.party_id = HZP.party_id;