DBA Data[Home] [Help]

APPS.AMW_PROC_APPROVAL_PKG dependencies on AMW_OBJECTIVE_ASSOCIATIONS

Line 343: update amw_objective_associations

339: and object_type = 'PROCESS'
340: and deletion_date is not null
341: and deletion_approval_date is null;
342:
343: update amw_objective_associations
344: set approval_date = APPROV_TXN_DATE
345: where pk1 = p_process_id
346: and object_type in ('PROCESS', 'CONTROL')
347: and approval_date is null;

Line 349: update amw_objective_associations

345: where pk1 = p_process_id
346: and object_type in ('PROCESS', 'CONTROL')
347: and approval_date is null;
348:
349: update amw_objective_associations
350: set deletion_approval_date = APPROV_TXN_DATE
351: where pk1 = p_process_id
352: and object_type in ('PROCESS', 'CONTROL')
353: and deletion_date is not null