DBA Data[Home] [Help]

APPS.AMW_RL_HIERARCHY_PKG dependencies on AMW_ACCT_ASSOCIATIONS

Line 3936: delete from amw_acct_associations

3932: IF SQL%FOUND THEN
3933: l_control_exists := TRUE;
3934: END IF;
3935:
3936: delete from amw_acct_associations
3937: where pk1 = p_process_id
3938: and approval_date is null
3939: and object_type = 'PROCESS';
3940:

Line 3941: update amw_acct_associations

3937: where pk1 = p_process_id
3938: and approval_date is null
3939: and object_type = 'PROCESS';
3940:
3941: update amw_acct_associations
3942: set deletion_date = null
3943: where pk1 = p_process_id
3944: and object_type = 'PROCESS'
3945: and deletion_date is not null