DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on AR_RECEIVABLES_TRX_ALL

Line 701: -- bug 5722367 removed the reference to ar_receivables_trx_all table to ar_receivables_trx

697: CE_AUTO_BANK_REC.G_receivables_trx_id);
698:
699: cep_standard.debug( 'x_receivables_trx_id= '|| x_receivables_trx_id);
700:
701: -- bug 5722367 removed the reference to ar_receivables_trx_all table to ar_receivables_trx
702: if (x_receivables_trx_id is not null) THEN
703:
704: -- Bug 16568960 Introduced EXCEPTION block to handle NO_DATA_FOUND
705: begin

Line 712: cep_standard.debug( 'NO_DATA_FOUND in AR_RECEIVABLES_TRX, picking up org_id from AR_RECEIVABLES_TRX_ALL..');

708: from AR_RECEIVABLES_TRX
709: where RECEIVABLES_TRX_ID = x_receivables_trx_id;
710: exception
711: when no_data_found then
712: cep_standard.debug( 'NO_DATA_FOUND in AR_RECEIVABLES_TRX, picking up org_id from AR_RECEIVABLES_TRX_ALL..');
713: select org_id
714: into X_ORG_ID
715: from AR_RECEIVABLES_TRX_ALL
716: where RECEIVABLES_TRX_ID = x_receivables_trx_id;

Line 715: from AR_RECEIVABLES_TRX_ALL

711: when no_data_found then
712: cep_standard.debug( 'NO_DATA_FOUND in AR_RECEIVABLES_TRX, picking up org_id from AR_RECEIVABLES_TRX_ALL..');
713: select org_id
714: into X_ORG_ID
715: from AR_RECEIVABLES_TRX_ALL
716: where RECEIVABLES_TRX_ID = x_receivables_trx_id;
717: end;
718: -- Bug 16568960 End.
719: