APPS.PA_PROJECT_PVT dependencies on PA_PROJECT_ROLE_TYPES_VL

Line 10695: --Bug#10124493 - project_role_type validation should be from pa_project_role_types_vl view

10691: p_pa_source_template_id IN NUMBER ,
10692: p_project_id IN NUMBER ,
10693: p_org_roles IN pa_project_pub.project_role_tbl_type )
10694: IS
10695: --Bug#10124493 - project_role_type validation should be from pa_project_role_types_vl view
10696: CURSOR l_project_role_types_csr (p_role_type IN VARCHAR2)
10697: IS
10698: SELECT 'x' FROM
10699: pa_project_role_types_vl role,

Line 10699: pa_project_role_types_vl role,

10695: --Bug#10124493 - project_role_type validation should be from pa_project_role_types_vl view
10696: CURSOR l_project_role_types_csr (p_role_type IN VARCHAR2)
10697: IS
10698: SELECT 'x' FROM
10699: pa_project_role_types_vl role,
10700: fnd_lookup_values lookup
10701: WHERE role.project_role_type = p_role_type
10702: and lookup.lookup_type='PA_ORGANIZATION_ROLE_CLASSES'
10703: and role.role_party_class=lookup.lookup_code

Line 10842: --Bug#10124493 - project_role_type should be taken from pa_project_role_types_vl view

10838: From dual;
10839: */ --Commented and added the following line -- By Ansari
10840: v_start_date_active := null;
10841:
10842: --Bug#10124493 - project_role_type should be taken from pa_project_role_types_vl view
10843: Select role.project_role_id
10844: Into v_project_role_id
10845: From pa_project_role_types_vl role,
10846: fnd_lookup_values lookup

Line 10845: From pa_project_role_types_vl role,

10841:
10842: --Bug#10124493 - project_role_type should be taken from pa_project_role_types_vl view
10843: Select role.project_role_id
10844: Into v_project_role_id
10845: From pa_project_role_types_vl role,
10846: fnd_lookup_values lookup
10847: WHERE role.project_role_type = p_org_roles(i).project_role_type
10848: and lookup.lookup_type='PA_ORGANIZATION_ROLE_CLASSES'
10849: and role.role_party_class=lookup.lookup_code