DBA Data[Home] [Help]

APPS.AMW_AP_APPROVAL_PVT dependencies on AMW_AP_ASSOCIATIONS

Line 1182: update amw_ap_associations

1178: -- AMW.D Update the control associations (set approval_date)
1179: select audit_procedure_id into l_ap_id
1180: from amw_audit_procedures_b
1181: where audit_procedure_rev_id = l_ap_rev_id;
1182: update amw_ap_associations
1183: set approval_date = l_approval_date
1184: where audit_procedure_id = l_ap_id
1185: and object_type = 'CTRL'
1186: and approval_date is null;

Line 1188: update amw_ap_associations

1184: where audit_procedure_id = l_ap_id
1185: and object_type = 'CTRL'
1186: and approval_date is null;
1187:
1188: update amw_ap_associations
1189: set deletion_approval_date = l_approval_date
1190: where audit_procedure_id = l_ap_id
1191: and object_type = 'CTRL'
1192: and deletion_date is not null