APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_APPROVED_HIERARCHIES

Line 2570: from amw_approved_hierarchies

2566: LAST_UPDATE_LOGIN ,
2567: SECURITY_GROUP_ID ,
2568: OBJECT_VERSION_NUMBER )
2569: (select P_CERTIFICATION_ID, P_PROCESS_ID, child_id, P_ORGANIZATION_ID, 1, sysdate, 1, sysdate, 1, null, 1
2570: from amw_approved_hierarchies
2571: start with parent_id = P_PROCESS_ID AND ORGANIZATION_ID = P_ORGANIZATION_ID
2572: and start_date is not null and end_date is null
2573: CONNECT BY PRIOR CHILD_ID = PARENT_ID AND ORGANIZATION_ID = P_ORGANIZATION_ID
2574: and start_date is not null and end_date is null

Line 2602: from amw_approved_hierarchies

2598: LAST_UPDATE_LOGIN ,
2599: SECURITY_GROUP_ID ,
2600: OBJECT_VERSION_NUMBER )
2601: (select P_CERTIFICATION_ID, P_PROCESS_ID, child_id, P_ORGANIZATION_ID, 1, sysdate, 1, sysdate, 1, null, 1
2602: from amw_approved_hierarchies
2603: start with parent_id = P_PROCESS_ID AND ORGANIZATION_ID = P_ORGANIZATION_ID
2604: and start_date is not null and end_date is null
2605: CONNECT BY PRIOR CHILD_ID = PARENT_ID AND ORGANIZATION_ID = P_ORGANIZATION_ID
2606: and start_date is not null and end_date is null);

Line 2631: FROM AMW_APPROVED_HIERARCHIES

2627: PARENT_PROCESS_ID,
2628: CHILD_PROCESS_ID,
2629: ORGANIZATION_ID)
2630: (SELECT distinct P_CERTIFICATION_ID, P_PROCESS_ID, child_id, organization_id
2631: FROM AMW_APPROVED_HIERARCHIES
2632: START WITH parent_id = P_PROCESS_ID
2633: AND organization_id = P_ORGANIZATION_ID
2634: CONNECT BY prior child_id = parent_id
2635: AND prior organization_id = organization_id

Line 2646: FROM AMW_APPROVED_HIERARCHIES

2642: PARENT_PROCESS_ID,
2643: CHILD_PROCESS_ID,
2644: ORGANIZATION_ID)
2645: SELECT distinct P_CERTIFICATION_ID, P_PROCESS_ID, child_id, organization_id
2646: FROM AMW_APPROVED_HIERARCHIES
2647: START WITH parent_id = P_PROCESS_ID
2648: AND organization_id = P_ORGANIZATION_ID
2649: CONNECT BY prior child_id = parent_id
2650: AND prior organization_id = organization_id;