DBA Data[Home] [Help]

APPS.FUN_REPORT_PVT dependencies on FND_USER

Line 44: FND_USER U,

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

Line 315: FND_USER U,

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

Line 707: FND_USER U,

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

Line 962: FND_USER U,

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