DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on PA_PROJECT_PARTIES

Line 100: FROM pa_project_parties ppp

96:
97: Cursor c_proj_manager (l_project_id NUMBER)
98: IS
99: SELECT ppp.resource_source_id manager_employee_id
100: FROM pa_project_parties ppp
101: ,per_all_people_f pe
102: WHERE ppp.project_id = l_project_id
103: AND ppp.project_role_id = 1
104: AND ppp.resource_type_id = 101