DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PER_ALL_PEOPLE_F

Line 7645: FROM per_all_people_f p,

7641: AND pst.structure_type = c_structure_type ;
7642:
7643: CURSOR cur_get_person_id(c_user_id NUMBER) IS
7644: SELECT p.person_id
7645: FROM per_all_people_f p,
7646: fnd_user f
7647: WHERE f.employee_id = p.person_id
7648: AND sysdate between p.effective_start_date and p.effective_end_date
7649: AND f.user_id = c_user_id;

Line 10804: from per_all_people_f p, fnd_user f

10800:
10801: --bug 2838547
10802: cursor get_person_id(p_user_id NUMBER) IS
10803: select p.person_id
10804: from per_all_people_f p, fnd_user f
10805: where f.employee_id = p.person_id
10806: and sysdate between p.effective_start_date and p.effective_end_date
10807: and f.user_id = p_user_id;
10808: