DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on AR_RECEIVABLES_TRX

Line 2307: ar_receivables_trx r

2303: INTO l_adj_number,
2304: l_recov_flag,
2305: l_tax_adjusted /* Bug 8512053 */
2306: FROM ar_adjustments a,
2307: ar_receivables_trx r
2308: WHERE a.adjustment_id = p_adj_id
2309: AND a.receivables_trx_id = r.receivables_trx_id
2310: AND a.org_id = r.org_id;
2311:

Line 2363: ar_receivables_trx earn,

2359: into l_adj_number,
2360: l_recov_flag
2361: from ar_cash_receipts cr,
2362: ar_receipt_method_accounts arm,
2363: ar_receivables_trx earn,
2364: ar_receivables_trx unearn
2365: where cr.cash_receipt_id = p_adj_id
2366: and cr.receipt_method_id = arm.receipt_method_id
2367: and arm.edisc_receivables_trx_id = earn.receivables_trx_id (+)

Line 2364: ar_receivables_trx unearn

2360: l_recov_flag
2361: from ar_cash_receipts cr,
2362: ar_receipt_method_accounts arm,
2363: ar_receivables_trx earn,
2364: ar_receivables_trx unearn
2365: where cr.cash_receipt_id = p_adj_id
2366: and cr.receipt_method_id = arm.receipt_method_id
2367: and arm.edisc_receivables_trx_id = earn.receivables_trx_id (+)
2368: and arm.unedisc_receivables_trx_id = unearn.receivables_trx_id (+)

Line 3587: ar_receivables_trx rt

3583: INTO l_tax_recov,
3584: l_rec_act_id
3585: FROM ar_cash_receipts cr,
3586: ar_receipt_method_accounts arm,
3587: ar_receivables_trx rt
3588: WHERE cr.cash_receipt_id = p_receipt_id
3589: AND cr.receipt_method_id = arm.receipt_method_id
3590: AND cr.remit_bank_acct_use_id = arm.remit_bank_acct_use_id
3591: AND DECODE(p_mode,