APPS.PA_PROJECT_PVT dependencies on PA_PROJECT_ROLE_TYPES_V

Line 82: FROM pa_project_role_types_v roles,

78:
79: CURSOR l_project_role_types_csr(p_role_type IN VARCHAR2,p_project_id IN number)
80: IS
81: SELECT 'x'
82: FROM pa_project_role_types_v roles,
83: pa_role_controls controls,
84: pa_projects_all proj
85: WHERE proj.project_id = p_project_id
86: AND proj.ROLE_LIST_ID is null

Line 93: FROM pa_project_role_types_v roles,

89: AND controls.role_control_code = 'ALLOW_AS_PROJ_MEMBER'
90: AND trunc(sysdate) between start_date_active and nvl(end_date_active,sysdate)
91: UNION ALL
92: SELECT 'x'
93: FROM pa_project_role_types_v roles,
94: pa_role_controls controls,
95: pa_projects_all proj,
96: pa_role_list_members prlm
97: WHERE proj.project_id = p_project_id

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