DBA Data[Home] [Help]

APPS.FUN_REPORT_PVT dependencies on DUAL

Line 46: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR

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;
50: EXCEPTION

Line 317: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR

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;
321:

Line 709: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR

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;
713: EXCEPTION

Line 964: (SELECT FND_GLOBAL.user_id() AS user_id FROM DUAL) CURR

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;
968: