DBA Data[Home] [Help]

APPS.PA_PROJECT_UTILS dependencies on FND_USER

Line 2407: FROM per_all_people_f papf, fnd_user usr

2403: l_person_id NUMBER;
2404: BEGIN
2405:
2406: SELECT papf.person_id into l_person_id
2407: FROM per_all_people_f papf, fnd_user usr
2408: WHERE papf.person_id = usr.employee_id
2409: AND trunc(sysdate) between papf.effective_start_date
2410: AND nvl(papf.effective_end_date, sysdate+1)
2411: AND trunc(sysdate) between usr.start_date