APPS.AMW_WF_HIERARCHY_PKG dependencies on AMW_RISK_ASSOCIATIONS

Line 613: from amw_risk_associations ara

609:
610: update amw_process ap
611: set risk_count =
612: (select count(ara.risk_id)
613: from amw_risk_associations ara
614: where pk1 = ap.process_id
615: and object_type = 'PROCESS'),
616: control_count =
617: (select count(distinct aca.control_id)

Line 618: from amw_control_associations aca, amw_risk_associations ara

614: where pk1 = ap.process_id
615: and object_type = 'PROCESS'),
616: control_count =
617: (select count(distinct aca.control_id)
618: from amw_control_associations aca, amw_risk_associations ara
619: where ara.pk1 = ap.process_id
620: and ara.object_type = 'PROCESS'
621: and aca.pk1 = ara.risk_id
622: and aca.object_type = 'RISK');

Line 708: from amw_risk_associations ara

704: begin
705: update amw_process_organization apo
706: set risk_count =
707: (select count(ara.risk_id)
708: from amw_risk_associations ara
709: where pk1 = apo.process_organization_id
710: and object_type = 'PROCESS_ORG'),
711: control_count =
712: (select count(distinct aca.control_id)

Line 713: from amw_control_associations aca, amw_risk_associations ara

709: where pk1 = apo.process_organization_id
710: and object_type = 'PROCESS_ORG'),
711: control_count =
712: (select count(distinct aca.control_id)
713: from amw_control_associations aca, amw_risk_associations ara
714: where ara.pk1 = apo.process_organization_id
715: and ara.object_type = 'PROCESS_ORG'
716: and aca.pk1 = ara.risk_association_id
717: and aca.object_type = 'RISK_ORG')

Line 3058: -- DELETE from amw_risk_associations

3054:
3055: -- this produces PLS-00801: internal error [74301] during compilation!
3056: -- delete risk associations in the risk library.
3057: -- FORALL v_ind IN 1..delete_row_cnt
3058: -- DELETE from amw_risk_associations
3059: -- where pk1 = v_amwp_name_pid( v_delete_list(v_ind) )
3060: -- and object_type = 'PROCESS';
3061:
3062: -- delete risk associations in the risk library.

Line 3131: DELETE from amw_risk_associations

3127: end loop;
3128:
3129:
3130: FORALL v_ind IN 1..delete_row_cnt
3131: DELETE from amw_risk_associations
3132: where pk1 = v_delete_pid_list(v_ind)
3133: and object_type = 'PROCESS';
3134:
3135: FORALL v_ind IN 1..delete_row_cnt

Line 3384: DELETE from amw_risk_associations

3380: end loop;
3381:
3382:
3383: FORALL v_ind IN 1..delete_row_cnt
3384: DELETE from amw_risk_associations
3385: where pk1 = v_delete_pid_list(v_ind)
3386: and object_type = 'PROCESS';
3387:
3388: FORALL v_ind IN 1..delete_row_cnt