APPS.PA_ROLE_UTILS dependencies on PA_PROJECT_ROLE_TYPES_B

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 40: pa_project_role_types_b */

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
44: 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 137: pa_project_role_types_b */

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
141: NVL(end_date_active,TRUNC(SYSDATE));

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 479: pa_project_role_types_b */

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;
483:

Line 538: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types to

534: --select '1'
535: --from dual
536: --where exists
537: select 'Y'
538: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types to
539: pa_project_role_types_b */
540: where project_role_id in (1,2,3,4)
541: and project_role_id=p_role_id
542: AND ROWNUM =1;

Line 539: pa_project_role_types_b */

535: --from dual
536: --where exists
537: select 'Y'
538: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types to
539: pa_project_role_types_b */
540: where project_role_id in (1,2,3,4)
541: and project_role_id=p_role_id
542: AND ROWNUM =1;
543: v_dummy varchar2(1);