DBA Data[Home] [Help]

APPS.AMW_PROCCERT_EVENT_PVT dependencies on AMW_ENTITY_HIERARCHIES

Line 1270: FROM amw_entity_hierarchies

1266: FROM amw_org_cert_eval_sum
1267: WHERE certification_id = l_cert_id
1268: AND organization_id IN (
1269: SELECT parent_object_id
1270: FROM amw_entity_hierarchies
1271: START WITH entity_type = 'BUSIPROC_CERTIFICATION'
1272: AND entity_id = l_org_id
1273: AND object_type = 'ORG'
1274: AND object_id = l_cert_id

Line 1336: FROM amw_entity_hierarchies

1332: AND scp.process_org_rev_id = procorg.process_org_rev_id
1333: AND procorg.standard_variation = proc.process_rev_id))
1334: AND organization_id in (
1335: SELECT parent_object_id
1336: FROM amw_entity_hierarchies
1337: START WITH entity_type = 'BUSIPROC_CERTIFICATION'
1338: AND entity_id = l_cert_id
1339: AND object_type = 'ORG'
1340: AND object_id = l_org_id