DBA Data[Home] [Help]

APPS.PA_DCTN_APRV_NOTIFICATION dependencies on PER_ALL_PEOPLE_F

Line 34: ,PER_ALL_PEOPLE_F pe

30:
31: CURSOR c_proj_manager (l_project_id NUMBER) IS
32: SELECT ppp.resource_source_id manager_employee_id
33: FROM PA_PROJECT_PARTIES ppp
34: ,PER_ALL_PEOPLE_F pe
35: WHERE ppp.project_id = l_project_id
36: AND ppp.project_role_id = 1
37: AND ppp.resource_type_id = 101
38: AND ppp.resource_source_id = pe.person_id