APPS.AMW_PROCESS_CERT_SUMMARY dependencies on AMW_OPINIONS_LOG

Line 30: FROM amw_opinions_log opin

26: CLOSE c_obj_opin_type_id;
27:
28: UPDATE amw_risk_associations assoc
29: SET pk4 = (SELECT max(opinion_log_id)
30: FROM amw_opinions_log opin
31: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id
32: AND opin.pk1_value = assoc.risk_id
33: AND opin.pk3_value = assoc.pk2 -- organization_id
34: AND NVL(opin.pk4_value, -1) =

Line 48: FROM amw_opinions_log opin

44: CLOSE c_obj_opin_type_id;
45:
46: UPDATE amw_control_associations assoc
47: SET pk5 = (SELECT max(opinion_log_id)
48: FROM amw_opinions_log opin
49: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id
50: AND opin.pk1_value = assoc.control_id
51: AND opin.pk3_value = assoc.pk2) -- organization_id
52: ,last_update_date = sysdate

Line 64: FROM amw_opinions_log opin

60:
61:
62: UPDATE amw_ap_associations assoc
63: SET pk4 = (SELECT max(opinion_log_id)
64: FROM amw_opinions_log opin
65: WHERE opin.object_opinion_type_id = l_obj_opinion_type_id
66: AND opin.pk1_value = assoc.pk3 --control_id
67: AND opin.pk3_value = assoc.pk2 -- organization_id
68: AND opin.pk4_value = assoc.audit_procedure_id) -- audit_procedure_id

Line 117: FROM amw_opinions_log_v opinion

113:
114: CURSOR get_evaluation_opinion_log
115: IS
116: SELECT opinion.opinion_log_id
117: FROM amw_opinions_log_v opinion
118: WHERE (opinion.authored_date in (SELECT MAX(opinion2.authored_date)
119: FROM amw_opinions opinion2
120: WHERE opinion2.object_opinion_type_id = opinion.object_opinion_type_id
121: AND opinion2.pk1_value = opinion.pk1_value