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