DBA Data[Home] [Help]

APPS.PA_PWP_NOTIFICATION dependencies on PA_PROJECT_PARTIES

Line 103: FROM pa_project_parties ppp

99:
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