APPS.PA_PROJECT_REQUEST_PVT dependencies on PA_PROJECT_ROLE_TYPES

Line 586: pa_project_role_types rt,

582: SELECT
583: rt.project_role_type,
584: rdv.resource_name
585: FROM
586: pa_project_role_types rt,
587: pa_proj_request_directory_v rdv
588: WHERE
589: rdv.request_id = p_request_id
590: AND rt.project_role_id =rdv.project_role_id

Line 768: from pa_project_role_types_vl

764: if (l_org_role_id is not null) then
765: BEGIN
766: select project_role_type
767: into l_org_role_type
768: from pa_project_role_types_vl
769: where project_role_id = l_org_role_id;
770: EXCEPTION WHEN NO_DATA_FOUND THEN
771: l_org_role_type := null;
772: debug('No org role type for role.');

Line 1674: PA_PROJECT_ROLE_TYPES PPRT

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'
1678: OR PPRT.PROJECT_ROLE_TYPE ='STAFFING OWNER')