DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on PER_ALL_PEOPLE_F

Line 104: ,per_all_people_f pe

100: Cursor c_proj_manager (l_project_id NUMBER)
101: IS
102: SELECT ppp.resource_source_id manager_employee_id
103: FROM pa_project_parties ppp
104: ,per_all_people_f pe
105: WHERE ppp.project_id = l_project_id
106: AND ppp.project_role_id = 1
107: AND ppp.resource_type_id = 101
108: AND ppp.resource_source_id = pe.person_id