40: BEGIN
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
311: BEGIN
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
703: BEGIN
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
958: BEGIN
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