APPS.AMW_PROC_ORG_APPROVAL_PKG dependencies on AMW_CURR_APP_HIERARCHY_ORG_V

Line 612: from AMW_CURR_APP_HIERARCHY_ORG_V

608: start with parent_process_id = -2
609: connect by prior child_process_id = parent_process_id)
610: MINUS
611: (select parent_process_id, child_process_id, child_order_number
612: from AMW_CURR_APP_HIERARCHY_ORG_V
613: where child_organization_id = p_org_id);
614: */
615:
616: -- these links must be deleted from the approved hierarchy

Line 619: (select parent_process_id, child_process_id from AMW_CURR_APP_HIERARCHY_ORG_V

615:
616: -- these links must be deleted from the approved hierarchy
617: -- executed when step = 2
618: CURSOR c2 is
619: (select parent_process_id, child_process_id from AMW_CURR_APP_HIERARCHY_ORG_V
620: where parent_process_id = p_process_id
621: and child_organization_id = p_org_id)
622: MINUS
623: (select parent_process_id, child_process_id from amw_latest_hierarchy_ORG_V

Line 632: (select parent_process_id, child_process_id from AMW_CURR_APP_HIERARCHY_ORG_V

628: -- defunct in the approved hierarchy ... we must remove those links
629: -- executed when step = 1
630: /* ksr commenting
631: CURSOR c3 is
632: (select parent_process_id, child_process_id from AMW_CURR_APP_HIERARCHY_ORG_V
633: where parent_process_id is not null
634: and child_organization_id = p_org_id)
635: MINUS
636: (select parent_process_id, child_process_id from

Line 637: (select * from AMW_CURR_APP_HIERARCHY_ORG_V where child_organization_id = p_org_id)

633: where parent_process_id is not null
634: and child_organization_id = p_org_id)
635: MINUS
636: (select parent_process_id, child_process_id from
637: (select * from AMW_CURR_APP_HIERARCHY_ORG_V where child_organization_id = p_org_id)
638: start with parent_process_id = -2
639: connect by prior child_process_id = parent_process_id);
640: */
641: