APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_ROLE_TYPES_VL

Line 689: from pa_project_role_types_vl

685: /* Adding new cursor for bug 6408593 */
686:
687: CURSOR c_prj_key_role_type(c_key_role_meaning IN VARCHAR) IS
688: select project_role_type
689: from pa_project_role_types_vl
690: where meaning like c_key_role_meaning;
691:
692: /*Added for bug 7830143*/
693: CURSOR c_get_org_id(c_project_id NUMBER) IS

Line 10018: pa_project_role_types_vl pprt,

10014: -999 USER_ID,
10015: ppp.resource_source_id RESOURCE_PARTY_ID
10016: FROM pa_project_parties ppp,
10017: pa_projects_all ppa,
10018: pa_project_role_types_vl pprt,
10019: hz_parties hzo,
10020: hz_contact_points hzcp
10021: WHERE ppp.resource_type_id = 112
10022: AND ppp.project_id = ppa.project_id

Line 10080: pa_project_role_types_vl pprt,

10076: -999 USER_ID,
10077: ppp.resource_source_id RESOURCE_PARTY_ID
10078: FROM pa_project_parties ppp,
10079: pa_projects_all ppa,
10080: pa_project_role_types_vl pprt,
10081: hz_parties hzo
10082: WHERE ppp.resource_type_id = 112
10083: AND ppp.project_id = ppa.project_id
10084: AND ppp.project_role_id = pprt.project_role_id