APPS.RCI_COMPL_ENV_CHG_SUMM_PKG dependencies on AMW_RISK_ASSOCIATIONS

Line 261: from amw_risk_associations

257: and organization_id = cur_rec.organization_id;
258:
259: select count(risk_id)
260: into l_risk_count
261: from amw_risk_associations
262: where object_type = 'PROCESS_FINCERT'
263: and pk1 = cur_rec.fin_certification_id
264: and pk2 = cur_rec.organization_id
265: and pk3 = cur_rec.process_id;

Line 505: from amw_risk_associations

501: and organization_id = cur_rec.organization_id;
502:
503: select count(risk_id)
504: into l_risk_count
505: from amw_risk_associations
506: where object_type = 'PROCESS_FINCERT'
507: and pk1 = cur_rec.fin_certification_id
508: and pk2 = cur_rec.organization_id
509: and pk3 = cur_rec.process_id;

Line 597: from amw_risk_associations

593: l_cnt2 number;
594: begin
595: select count(risk_id)
596: into l_cnt1
597: from amw_risk_associations
598: where object_type = 'PROCESS_FINCERT'
599: and pk1 = cert_id
600: and pk2 = org_id
601: and pk3 = process_id

Line 603: from amw_risk_associations

599: and pk1 = cert_id
600: and pk2 = org_id
601: and pk3 = process_id
602: and risk_id not in (select risk_id
603: from amw_risk_associations
604: where object_type = 'PROCESS_ORG'
605: and pk1 = org_id
606: and pk2 = process_id
607: and approval_date is not null

Line 613: from amw_risk_associations

609:
610:
611: select count(risk_id)
612: into l_cnt2
613: from amw_risk_associations
614: where object_type = 'PROCESS_ORG'
615: and pk1 = org_id
616: and pk2 = process_id
617: and approval_date is not null

Line 620: from amw_risk_associations

616: and pk2 = process_id
617: and approval_date is not null
618: and deletion_approval_date is null
619: and risk_id not in (select risk_id
620: from amw_risk_associations
621: where object_type = 'PROCESS_FINCERT'
622: and pk1 = cert_id
623: and pk2 = org_id
624: and pk3 = process_id);