APPS.AMW_PROC_APPROVAL_PKG dependencies on AMW_LATEST_HIERARCHY_RL_V

Line 100: from amw_latest_hierarchy_rl_v

96: CREATED_BY,
97: object_version_number)
98: (select -1, p_process_id, child_process_id, sysdate, G_USER_ID, G_LOGIN_ID,
99: sysdate, G_USER_ID, 1
100: from amw_latest_hierarchy_rl_v
101: where parent_process_id = p_process_id);
102:
103: elsif (approv_choice = 'C') then
104:

Line 389: from amw_latest_hierarchy_rl_v

385: (select parent_process_id,
386: child_process_id,
387: child_order_number
388: from (select *
389: from amw_latest_hierarchy_rl_v
390: where parent_approval_status = 'A'
391: and child_approval_status = 'A')
392: start with parent_process_id = -1
393: connect by prior child_process_id = parent_process_id)

Line 410: from amw_latest_hierarchy_rl_v

406: where parent_process_id = p_process_id)
407: MINUS
408: (select parent_process_id,
409: child_process_id
410: from amw_latest_hierarchy_rl_v
411: where parent_process_id = p_process_id);
412:
413:
414: -- 05.11.2005 npanandi: added below cursor for WebADI call

Line 424: from amw_latest_hierarchy_rl_v);

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);
425:
426:
427: -- as a result of the children being removed in c2 some links may become
428: -- defunct in the approved hierarchy ... we must remove those links