1329: AND scp.entity_type = 'BUSIPROC_CERTIFICATION'
1330: AND scp.organization_id = l_org_id
1331: AND scp.process_id = l_process_id
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'