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