DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on AR_RECEIVABLES_TRX

Line 2236: ar_receivables_trx r

2232: SELECT a.adjustment_number, r.tax_recoverable_flag
2233: INTO l_adj_number,
2234: l_recov_flag
2235: FROM ar_adjustments a,
2236: ar_receivables_trx r
2237: WHERE a.adjustment_id = p_adj_id
2238: AND a.receivables_trx_id = r.receivables_trx_id
2239: AND a.org_id = r.org_id;
2240:

Line 2292: ar_receivables_trx earn,

2288: into l_adj_number,
2289: l_recov_flag
2290: from ar_cash_receipts cr,
2291: ar_receipt_method_accounts arm,
2292: ar_receivables_trx earn,
2293: ar_receivables_trx unearn
2294: where cr.cash_receipt_id = p_adj_id
2295: and cr.receipt_method_id = arm.receipt_method_id
2296: and arm.edisc_receivables_trx_id = earn.receivables_trx_id (+)

Line 2293: ar_receivables_trx unearn

2289: l_recov_flag
2290: from ar_cash_receipts cr,
2291: ar_receipt_method_accounts arm,
2292: ar_receivables_trx earn,
2293: ar_receivables_trx unearn
2294: where cr.cash_receipt_id = p_adj_id
2295: and cr.receipt_method_id = arm.receipt_method_id
2296: and arm.edisc_receivables_trx_id = earn.receivables_trx_id (+)
2297: and arm.unedisc_receivables_trx_id = unearn.receivables_trx_id (+)

Line 3525: ar_receivables_trx rt

3521: INTO l_tax_recov,
3522: l_rec_act_id
3523: FROM ar_cash_receipts cr,
3524: ar_receipt_method_accounts arm,
3525: ar_receivables_trx rt
3526: WHERE cr.cash_receipt_id = p_receipt_id
3527: AND cr.receipt_method_id = arm.receipt_method_id
3528: AND cr.remit_bank_acct_use_id = arm.remit_bank_acct_use_id
3529: AND DECODE(p_mode,