APPS.RCI_COMPL_ENV_CHG_SUMM_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

Line 269: from amw_control_associations

265: and pk3 = cur_rec.process_id;
266:
267: select count(control_id)
268: into l_control_count
269: from amw_control_associations
270: where object_type = 'RISK_FINCERT'
271: and pk1 = cur_rec.fin_certification_id
272: and pk2 = cur_rec.organization_id
273: and pk3 = cur_rec.process_id;

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 513: from amw_control_associations

509: and pk3 = cur_rec.process_id;
510:
511: select count(control_id)
512: into l_control_count
513: from amw_control_associations
514: where object_type = 'RISK_FINCERT'
515: and pk1 = cur_rec.fin_certification_id
516: and pk2 = cur_rec.organization_id
517: 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

Line 639: from amw_control_associations

635: l_cnt2 number;
636: begin
637: select count(control_id)
638: into l_cnt1
639: from amw_control_associations
640: where object_type = 'RISK_FINCERT'
641: and pk1 = cert_id
642: and pk2 = org_id
643: and pk3 = process_id

Line 645: from amw_control_associations

641: and pk1 = cert_id
642: and pk2 = org_id
643: and pk3 = process_id
644: and control_id not in (select control_id
645: from amw_control_associations
646: where object_type = 'RISK_ORG'
647: and pk1 = org_id
648: and pk2 = process_id
649: and approval_date is not null

Line 654: from amw_control_associations

650: and deletion_approval_date is null);
651:
652: select count(control_id)
653: into l_cnt2
654: from amw_control_associations
655: where object_type = 'RISK_ORG'
656: and pk1 = org_id
657: and pk2 = process_id
658: and approval_date is not null

Line 661: from amw_control_associations

657: and pk2 = process_id
658: and approval_date is not null
659: and deletion_approval_date is null
660: and control_id not in (select control_id
661: from amw_control_associations
662: where object_type = 'RISK_FINCERT'
663: and pk1 = cert_id
664: and pk2 = org_id
665: and pk3 = process_id);