APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_ROLE_TYPES_VL

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