DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on FND_USER

Line 7895: fnd_user f

7891:
7892: CURSOR cur_get_person_id(c_user_id NUMBER) IS
7893: SELECT p.person_id
7894: FROM per_all_people_f p,
7895: fnd_user f
7896: WHERE f.employee_id = p.person_id
7897: AND sysdate between p.effective_start_date and p.effective_end_date
7898: AND f.user_id = c_user_id;
7899:

Line 11119: from per_all_people_f p, fnd_user f

11115:
11116: --bug 2838547
11117: cursor get_person_id(p_user_id NUMBER) IS
11118: select p.person_id
11119: from per_all_people_f p, fnd_user f
11120: where f.employee_id = p.person_id
11121: and sysdate between p.effective_start_date and p.effective_end_date
11122: and f.user_id = p_user_id;
11123: