DBA Data[Home] [Help]

APPS.PA_PROJECT_REQUEST_PVT dependencies on PA_PROJECT_PARTIES

Line 1673: FROM PA_PROJECT_PARTIES PPP ,

1669:
1670: CURSOR cur_wf_ntf_info (p_project_id NUMBER) IS
1671: SELECT PPP.RESOURCE_SOURCE_ID,
1672: PPRT.PROJECT_ROLE_TYPE
1673: FROM PA_PROJECT_PARTIES PPP ,
1674: PA_PROJECT_ROLE_TYPES PPRT
1675: WHERE PPP.PROJECT_ID = p_project_id
1676: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
1677: AND (PPRT.PROJECT_ROLE_TYPE ='PROJECT MANAGER'