DBA Data[Home] [Help]

APPS.AMW_PROC_ORG_APPROVAL_PKG dependencies on AMW_ACCT_ASSOCIATIONS

Line 512: update amw_acct_associations

508: and object_type = 'RISK_ORG'
509: and deletion_date is not null
510: and deletion_approval_date is null;
511:
512: update amw_acct_associations
513: set approval_date = APPROV_TXN_DATE
514: where pk2 = p_process_id
515: and pk1 = p_org_id
516: and object_type = 'PROCESS_ORG'

Line 519: update amw_acct_associations

515: and pk1 = p_org_id
516: and object_type = 'PROCESS_ORG'
517: and approval_date is null;
518:
519: update amw_acct_associations
520: set deletion_approval_date = APPROV_TXN_DATE
521: where pk2 = p_process_id
522: and pk1 = p_org_id
523: and object_type = 'PROCESS_ORG'