DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on FND_USER

Line 959: from per_all_people_f p, fnd_user f

955: l_structure_version_desc VARCHAR2(2000);
956:
957: cursor get_person_id(p_user_id NUMBER) IS
958: select p.person_id
959: from per_all_people_f p, fnd_user f
960: where f.employee_id = p.person_id
961: and sysdate between p.effective_start_date and p.effective_end_date
962: and f.user_id = p_user_id;
963:

Line 1786: from per_all_people_f p, fnd_user f

1782: l_person_id NUMBER;
1783:
1784: cursor get_person_id(p_user_id NUMBER) IS
1785: select p.person_id
1786: from per_all_people_f p, fnd_user f
1787: where f.employee_id = p.person_id
1788: and sysdate between p.effective_start_date and p.effective_end_date
1789: and f.user_id = p_user_id;
1790: