APPS.RCI_PROC_CERT_SUMM_PKG dependencies on AMW_CONTROLS_ALL_VL

Line 799: amw_controls_all_vl acav,

795: count(nvl(ctrlevalopin.audit_result_code,1)) cnt
796: FROM
797: (SELECT object_type,control_id,pk1,pk2,pk3,pk4,pk5,control_rev_id
798: FROM amw_control_associations WHERE object_type='BUSIPROC_CERTIFICATION') aca,
799: amw_controls_all_vl acav,
800: amw_opinions_log_v ctrlevalopin
801: WHERE
802: aca.pk1(+)=p_cert_id
803: AND aca.pk2(+)=p_org_id

Line 967: amw_controls_all_vl acav,

963: count(nvl(ctrlevalopin.audit_result_code,1)) cnt
964: FROM
965: (SELECT object_type,control_id,pk1,pk2,pk3,pk4,pk5,control_rev_id
966: FROM amw_control_associations WHERE object_type='BUSIPROC_CERTIFICATION') aca,
967: amw_controls_all_vl acav,
968: amw_opinions_log_v ctrlevalopin
969: WHERE
970: aca.pk1(+)=cert_rec.cert_id
971: AND aca.pk2(+)=p_org_id