APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_ROLE_TYPES_V

Line 656: from pa_project_role_types_vl

652: /* Adding new cursor for bug 6408593 */
653:
654: CURSOR c_prj_key_role_type(c_key_role_meaning IN VARCHAR) IS
655: select project_role_type
656: from pa_project_role_types_vl
657: where meaning like c_key_role_meaning;
658:
659: /*Added for bug 7830143*/
660: CURSOR c_get_org_id(c_project_id NUMBER) IS

Line 9766: pa_project_role_types_vl pprt,

9762: -999 USER_ID,
9763: ppp.resource_source_id RESOURCE_PARTY_ID
9764: FROM pa_project_parties ppp,
9765: pa_projects_all ppa,
9766: pa_project_role_types_vl pprt,
9767: hz_parties hzo,
9768: hz_contact_points hzcp
9769: WHERE ppp.resource_type_id = 112
9770: AND ppp.project_id = ppa.project_id

Line 9828: pa_project_role_types_vl pprt,

9824: -999 USER_ID,
9825: ppp.resource_source_id RESOURCE_PARTY_ID
9826: FROM pa_project_parties ppp,
9827: pa_projects_all ppa,
9828: pa_project_role_types_vl pprt,
9829: hz_parties hzo
9830: WHERE ppp.resource_type_id = 112
9831: AND ppp.project_id = ppa.project_id
9832: AND ppp.project_role_id = pprt.project_role_id

Line 10488: from pa_project_role_types_v roles,

10484:
10485: CURSOR l_project_role_types_csr (p_role_type IN VARCHAR2,p_project_id IN number)
10486: IS
10487: select 'x'
10488: from pa_project_role_types_v roles,
10489: pa_role_controls controls,
10490: pa_projects_all proj
10491: where proj.project_id=p_project_id
10492: and proj.ROLE_LIST_ID is null

Line 10499: from pa_project_role_types_v roles,

10495: and controls.role_control_code='ALLOW_AS_PROJ_MEMBER'
10496: and trunc(sysdate) between start_date_active and nvl(end_date_active,sysdate)
10497: union all
10498: select 'x'
10499: from pa_project_role_types_v roles,
10500: pa_role_controls controls,
10501: pa_projects_all proj,
10502: pa_role_list_members prlm
10503: where proj.project_id=p_project_id