[Home] [Help]
APPS.RCI_ORG_DFCY_ETL_PKG dependencies on AMW_CONTROL_ASSOCIATIONS
Line 79: FROM amw_control_associations aca,
75: aca.pk2 organization_id,
76: aca.pk3 process_id,
77: aca.pk4 risk_id,
78: aca.control_id
79: FROM amw_control_associations aca,
80: amw_opinions_v aov
81: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
82: AND aca.pk1 = c_certification_id
83: AND aca.pk2 = c_organization_id