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.AMW_PROC_APPROVAL_PKG dependencies on AMW_CURR_APP_HIERARCHY_RL_V

Line 398: from AMW_CURR_APP_HIERARCHY_RL_V);

394: MINUS
395: (select parent_process_id,
396: child_process_id,
397: child_order_number
398: from AMW_CURR_APP_HIERARCHY_RL_V);
399:
400: -- these links must be deleted from the approved hierarchy
401: -- executed when step = 2
402: CURSOR c2 is

Line 405: from AMW_CURR_APP_HIERARCHY_RL_V

401: -- executed when step = 2
402: CURSOR c2 is
403: (select parent_process_id,
404: child_process_id
405: from AMW_CURR_APP_HIERARCHY_RL_V
406: where parent_process_id = p_process_id)
407: MINUS
408: (select parent_process_id,
409: child_process_id

Line 420: from AMW_CURR_APP_HIERARCHY_RL_V)

416: -- take pProcessId as a bind variable
417: CURSOR c2_1 is
418: (select parent_process_id,
419: child_process_id
420: from AMW_CURR_APP_HIERARCHY_RL_V)
421: MINUS
422: (select parent_process_id,
423: child_process_id
424: from amw_latest_hierarchy_rl_v);

Line 433: from AMW_CURR_APP_HIERARCHY_RL_V

429: -- executed when step = 1
430: CURSOR c3 is
431: (select parent_process_id,
432: child_process_id
433: from AMW_CURR_APP_HIERARCHY_RL_V
434: where parent_process_id is not null)
435: MINUS
436: (select parent_process_id,
437: child_process_id

Line 438: from AMW_CURR_APP_HIERARCHY_RL_V

434: where parent_process_id is not null)
435: MINUS
436: (select parent_process_id,
437: child_process_id
438: from AMW_CURR_APP_HIERARCHY_RL_V
439: start with parent_process_id = -1
440: connect by prior child_process_id = parent_process_id);
441: BEGIN
442: if ( (p_step = 1) or (p_step = 0) ) then