APPS.AMW_WF_HIERARCHY_PKG dependencies on AMW_CONTROL_ASSOCIATIONS

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 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')