400: --select '1'
401: --from dual
402: --where exists
403: select 'Y'
404: from pa_role_controls
405: where project_role_id=p_role_id
406: and role_control_code='ALLOW_SCHEDULE'
407: AND ROWNUM = 1;
408: v_dummy varchar2(1);
430: --select '1'
431: --from dual
432: --where exists
433: select 'Y'
434: from pa_role_controls
435: where project_role_id=p_role_id
436: and role_control_code='ALLOW_SCHEDULE'
437: AND ROWNUM =1;
438: v_dummy varchar2(1);
525: ,x_error_message_code out NOCOPY varchar2) is --File.Sql.39 bug 4440895
526: /* Fix for bug 1829383 */
527: cursor c_role_control is
528: select created_by
529: from pa_role_controls
530: where project_role_id=p_role_id
531: and role_control_code =p_role_control_code;
532: /* Fix for bug 1829383 */
533: cursor c_seed_roles is