DBA Data[Home] [Help]

APPS.AMW_PROCESS_CERT_SUMMARY dependencies on AMW_AP_ASSOCIATIONS

Line 62: UPDATE amw_ap_associations assoc

58: FETCH c_obj_opin_type_id INTO l_obj_opinion_type_id;
59: CLOSE c_obj_opin_type_id;
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