DBA Data[Home] [Help]

APPS.RCI_COMPL_ENV_CHG_SUMM_PKG dependencies on AMW_CONTROLS_ALL_VL

Line 277: from amw_control_associations ACA, AMW_CONTROLS_ALL_VL ACAV

273: and pk3 = cur_rec.process_id;
274:
275: select DECODE(count(ACA.control_id),0,'N','Y')
276: into l_key_control
277: from amw_control_associations ACA, AMW_CONTROLS_ALL_VL ACAV
278: where object_type = 'RISK_FINCERT'
279: and pk1 = cur_rec.fin_certification_id
280: and pk2 = cur_rec.organization_id
281: and pk3 = cur_rec.process_id

Line 521: from amw_control_associations ACA, AMW_CONTROLS_ALL_VL ACAV

517: and pk3 = cur_rec.process_id;
518:
519: select DECODE(count(ACA.control_id),0,'N','Y')
520: into l_key_control
521: from amw_control_associations ACA, AMW_CONTROLS_ALL_VL ACAV
522: where object_type = 'RISK_FINCERT'
523: and pk1 = cur_rec.fin_certification_id
524: and pk2 = cur_rec.organization_id
525: and pk3 = cur_rec.process_id