APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_ROLE_TYPES_V

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

Line 10750: from pa_project_role_types_v roles,

10746:
10747: CURSOR l_project_role_types_csr (p_role_type IN VARCHAR2,p_project_id IN number)
10748: IS
10749: select 'x'
10750: from pa_project_role_types_v roles,
10751: pa_role_controls controls,
10752: pa_projects_all proj
10753: where proj.project_id=p_project_id
10754: and proj.ROLE_LIST_ID is null

Line 10761: from pa_project_role_types_v roles,

10757: and controls.role_control_code='ALLOW_AS_PROJ_MEMBER'
10758: and trunc(sysdate) between start_date_active and nvl(end_date_active,sysdate)
10759: union all
10760: select 'x'
10761: from pa_project_role_types_v roles,
10762: pa_role_controls controls,
10763: pa_projects_all proj,
10764: pa_role_list_members prlm
10765: where proj.project_id=p_project_id