eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ROLE_UTILS dependencies on PA_ROLE_CONTROLS

Line 404: from pa_role_controls

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

Line 434: from pa_role_controls

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

Line 529: from pa_role_controls

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