APPS.PA_PROJECT_PVT dependencies on PA_PROJECT_ROLE_TYPES

Line 74: pa_project_role_types

70: /* modified the following cursor for Bug#5196996
71: CURSOR l_project_role_types_csr (p_role_type IN VARCHAR2)
72: IS
73: SELECT 'x' FROM
74: pa_project_role_types
75: WHERE project_role_type = p_role_type; */
76:
77: --This is the modified cursor Bug#5196996
78:

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 421: From pa_project_role_types

417: /*End of the code added for the bug 2910972*/
418:
419: Select project_role_id
420: Into v_project_role_id
421: From pa_project_role_types
422: Where project_role_type=p_key_members(i).project_role_type;
423:
424: v_end_date_active := p_key_members(i).end_date;
425: v_project_role_type := p_key_members(i).project_role_type;

Line 10358: pa_project_role_types

10354:
10355: CURSOR l_project_role_types_csr (p_role_type IN VARCHAR2)
10356: IS
10357: SELECT 'x' FROM
10358: pa_project_role_types
10359: WHERE project_role_type = p_role_type;
10360:
10361:
10362:

Line 10500: From pa_project_role_types

10496: v_start_date_active := null;
10497:
10498: Select project_role_id
10499: Into v_project_role_id
10500: From pa_project_role_types
10501: Where project_role_type=p_org_roles(i).project_role_type;
10502:
10503: v_end_date_active := p_org_roles(i).end_date;
10504: v_project_role_type := p_org_roles(i).project_role_type;