APPS.AMW_ORG_CERT_EVAL_SUM_PVT dependencies on AMW_RISK_ASSOCIATIONS

Line 165: FROM amw_risk_associations ara,amw_opinions_v aov

161: CURSOR get_unmitigated_risks
162: IS
163: SELECT count(1)
164: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
165: FROM amw_risk_associations ara,amw_opinions_v aov
166: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
167: AND ara.pk1 = p_certification_id
168: AND ara.pk2 = p_org_id
169: AND aov.object_name = 'AMW_ORG_PROCESS_RISK'

Line 190: FROM amw_risk_associations ara,amw_opinions_v aov

186: CURSOR get_evaluated_risks
187: IS
188: SELECT count(1)
189: FROM (SELECT DISTINCT ara.pk1 certification_id, ara.pk2 organization_id, ara.pk3 process_id, ara.risk_id
190: FROM amw_risk_associations ara,amw_opinions_v aov
191: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
192: AND ara.pk1 = p_certification_id
193: AND ara.pk2 = p_org_id
194: AND aov.object_name = 'AMW_ORG_PROCESS_RISK'

Line 209: FROM amw_risk_associations ara

205: ---07.05.2005 npanandi: added ara.pk3 below for processId --- bugfix for bug 4471783
206: ---10.03.2005 dliao: change count(pk3) to count(1) because of entity_risk
207: SELECT count(1) from (
208: select distinct ara.pk3, ara.risk_id
209: FROM amw_risk_associations ara
210: WHERE ara.object_type = 'BUSIPROC_CERTIFICATION'
211: AND ara.pk1 = p_certification_id
212: AND ara.pk2 = p_org_id);
213: