DBA Data[Home] [Help]

APPS.RCI_ORG_DFCY_ETL_PKG dependencies on AMW_EXECUTION_SCOPE

Line 45: FROM amw_execution_scope

41: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
42: AND ara.pk1 = c_certification_id
43: AND ara.pk2 = c_organization_id
44: AND ara.pk3 IN (SELECT DISTINCT process_id
45: FROM amw_execution_scope
46: START WITH process_id = c_process_id
47: AND organization_id = c_organization_id
48: AND entity_id = c_certification_id
49: and entity_type='BUSIPROC_CERTIFICATION'

Line 85: FROM amw_execution_scope

81: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
82: AND aca.pk1 = c_certification_id
83: AND aca.pk2 = c_organization_id
84: AND aca.pk3 IN (SELECT DISTINCT process_id
85: FROM amw_execution_scope
86: START WITH process_id = c_process_id
87: AND organization_id = c_organization_id
88: AND entity_id = c_certification_id
89: and entity_type='BUSIPROC_CERTIFICATION'