APPS.AMW_PROCCERT_EVENT_PVT dependencies on AMW_RISK_ASSOCIATIONS

Line 38: UPDATE amw_risk_associations assoc

34: OPEN c_obj_opin_type_id ('AMW_ORG_PROCESS_RISK');
35: FETCH c_obj_opin_type_id INTO l_obj_opinion_type_id;
36: CLOSE c_obj_opin_type_id;
37:
38: UPDATE amw_risk_associations assoc
39: SET last_update_date = sysdate,
40: last_updated_by = fnd_global.user_id,
41: last_update_login = fnd_global.conc_login_id,
42: pk4 = (SELECT max(opinion_log_id)

Line 250: FROM amw_certification_b cert, amw_risk_associations assoc,

246: AND psum.evaluation_opinion_log_id = opin.opinion_log_id(+);
247:
248: CURSOR c_cert_with_risk (c_risk_id NUMBER, c_proc_id NUMBER, c_org_id NUMBER) IS
249: SELECT cert.certification_id, opin.audit_result_code old_eval
250: FROM amw_certification_b cert, amw_risk_associations assoc,
251: amw_opinions_log_v opin
252: WHERE cert.certification_status in ('ACTIVE','DRAFT')
253: AND cert.certification_id = assoc.pk1
254: AND assoc.object_type = 'BUSIPROC_CERTIFICATION'

Line 827: UPDATE amw_risk_associations

823: END IF;
824: END LOOP;
825:
826: -- update amw_risk_association.pk4 with evaluation_opinion_log_id
827: UPDATE amw_risk_associations
828: SET last_update_date = sysdate,
829: last_updated_by = fnd_global.user_id,
830: last_update_login = fnd_global.conc_login_id,
831: pk4 = l_opin_log_id

Line 838: FROM amw_certification_b cert, amw_risk_associations assoc

834: AND pk2 = l_pk3 -- organization_id
835: AND NVL(pk3,-1) = NVL(l_pk4,-1) -- process_id
836: AND pk1 IN (
837: SELECT assoc.pk1
838: FROM amw_certification_b cert, amw_risk_associations assoc
839: WHERE cert.certification_status in ('ACTIVE','DRAFT')
840: AND cert.certification_id = assoc.pk1
841: AND assoc.object_type = 'BUSIPROC_CERTIFICATION'
842: AND assoc.risk_id = l_pk1