APPS.AMW_PROCCERT_EVENT_PVT dependencies on AMW_AP_ASSOCIATIONS

Line 74: UPDATE amw_ap_associations assoc

70: OPEN c_obj_opin_type_id ('AMW_ORG_AP_CONTROL');
71: FETCH c_obj_opin_type_id INTO l_obj_opinion_type_id;
72: CLOSE c_obj_opin_type_id;
73:
74: UPDATE amw_ap_associations assoc
75: SET last_update_date = sysdate,
76: last_updated_by = fnd_global.user_id,
77: last_update_login = fnd_global.conc_login_id,
78: pk4 = (SELECT max(opinion_log_id)

Line 1143: UPDATE amw_ap_associations

1139: AND assoc.control_id = l_pk1
1140: AND assoc.pk2 = l_pk3); -- organization_id
1141:
1142: ELSIF l_obj_name = 'AMW_ORG_AP_CONTROL' THEN
1143: UPDATE amw_ap_associations
1144: SET last_update_date = sysdate,
1145: last_updated_by = fnd_global.user_id,
1146: last_update_login = fnd_global.conc_login_id,
1147: pk4 = l_opin_log_id

Line 1154: FROM amw_certification_b cert, amw_ap_associations assoc

1150: AND pk2 = l_pk3 -- organization_id
1151: AND pk3 = l_pk4 -- control_id
1152: AND pk1 IN (
1153: SELECT assoc.pk1
1154: FROM amw_certification_b cert, amw_ap_associations assoc
1155: WHERE cert.certification_status in ('ACTIVE','DRAFT')
1156: AND cert.certification_id = assoc.pk1
1157: AND assoc.object_type = 'BUSIPROC_CERTIFICATION'
1158: AND assoc.audit_procedure_id = l_pk1