APPS.ARP_RECEIPTS_MAIN dependencies on AR_REC_TRX_LE_DETAILS

Line 1501: in ar_rec_trx_le_details. The following sql has

1497: THEN
1498: /* LE is in use */
1499:
1500: /* 5236782 - there are cases where no rows will exist
1501: in ar_rec_trx_le_details. The following sql has
1502: been modified to ignore these cases without error */
1503:
1504: select nvl(ed.gl_account_source,'NO_SOURCE') ,
1505: nvl(ed.tax_code_source,'NO_SOURCE') ,

Line 1538: ar_rec_trx_le_details edd,

1534: p_rule_rec.act_tax_non_rec_ccid2 ,
1535: p_rule_rec.act_vat_tax_id2
1536: from ar_receipt_method_accounts rma,
1537: ar_receivables_trx ed,
1538: ar_rec_trx_le_details edd,
1539: ar_receivables_trx uned,
1540: ar_rec_trx_le_details unedd
1541: where rma.receipt_method_id = p_cr_rec.receipt_method_id
1542: and rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id

Line 1540: ar_rec_trx_le_details unedd

1536: from ar_receipt_method_accounts rma,
1537: ar_receivables_trx ed,
1538: ar_rec_trx_le_details edd,
1539: ar_receivables_trx uned,
1540: ar_rec_trx_le_details unedd
1541: where rma.receipt_method_id = p_cr_rec.receipt_method_id
1542: and rma.remit_bank_acct_use_id = p_cr_rec.remit_bank_acct_use_id
1543: and rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)
1544: and ed.receivables_trx_id = edd.receivables_trx_id (+)