APPS.PA_ROLE_UTILS dependencies on PA_PROJECT_ROLE_TYPES_VL

Line 27: FROM pa_project_role_types_vl

23: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
24:
25: CURSOR c_ids IS
26: SELECT project_role_id
27: FROM pa_project_role_types_vl
28: WHERE meaning = p_role_name;
29: l_current_id NUMBER := NULL;
30: l_num_ids NUMBER:= 0;
31: l_id_found_flag VARCHAR(1) := 'N';

Line 39: FROM pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to

35: IF p_role_id IS NOT NULL AND p_role_id <> FND_API.G_MISS_NUM THEN
36: IF p_check_id_flag = 'Y' THEN
37: SELECT project_role_id
38: INTO x_role_id
39: FROM pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
40: pa_project_role_types_b */
41: WHERE project_role_id = p_role_id
42: AND TRUNC(SYSDATE) BETWEEN
43: start_date_active AND

Line 81: FROM pa_project_role_types_vl

77: ELSE
78: IF (p_role_name IS NOT NULL) then
79: SELECT project_role_id
80: INTO x_role_id
81: FROM pa_project_role_types_vl
82: WHERE meaning = p_role_name
83: AND TRUNC(SYSDATE) BETWEEN
84: start_date_active AND
85: NVL(end_date_active,TRUNC(SYSDATE));

Line 136: FROM pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to

132: IF p_role_id IS NOT NULL AND p_role_id <> FND_API.G_MISS_NUM THEN
133: IF p_check_id_flag = 'Y' THEN
134: SELECT project_role_id
135: INTO x_role_id
136: FROM pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
137: pa_project_role_types_b */
138: WHERE project_role_id = p_role_id
139: AND TRUNC(SYSDATE) BETWEEN
140: start_date_active AND

Line 148: FROM pa_project_role_types_vl

144: END IF;
145: ELSE
146: SELECT project_role_id
147: INTO x_role_id
148: FROM pa_project_role_types_vl
149: WHERE meaning = p_role_name
150: AND TRUNC(SYSDATE) BETWEEN
151: start_date_active AND
152: NVL(end_date_active,TRUNC(SYSDATE));

Line 288: FROM pa_project_role_types_vl

284: default_min_job_level,
285: default_max_job_level,
286: menu_id,
287: default_job_id
288: FROM pa_project_role_types_vl
289: WHERE project_role_id = p_role_id ;
290: BEGIN
291: pa_debug.init_err_stack ('pa_role_utils.get_role_defaults');
292: OPEN l_role_csr;

Line 478: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to

474: --select '1'
475: --from dual
476: --where exists
477: select 'Y'
478: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
479: pa_project_role_types_b */
480: where project_role_id in (1,2,3,4)
481: and project_role_id=p_role_id
482: AND ROWNUM =1;

Line 881: from pa_project_role_types_vl

877: ,x_return_status out NOCOPY varchar2 --File.Sql.39 bug 4440895
878: ,x_error_message_code out NOCOPY varchar2) IS --File.Sql.39 bug 4440895
879: cursor c_exist is
880: select 'y'
881: from pa_project_role_types_vl
882: where meaning =p_meaning;
883:
884: v_dummy varchar2(1) ;
885: begin