APPS.ARP_DEDUCTION dependencies on AR_RECEIVABLES_TRX

Line 2212: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;

2208: *=======================================================================*/
2209: FUNCTION GET_RECEIVABLES_TRX_ID
2210: (p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE) RETURN NUMBER IS
2211:
2212: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
2213:
2214: BEGIN
2215:
2216: IF PG_DEBUG in ('Y', 'C') THEN

Line 2222: FROM ar_receivables_trx rt

2218: END IF;
2219:
2220: SELECT rt.receivables_trx_id
2221: INTO l_receivables_trx_id
2222: FROM ar_receivables_trx rt
2223: WHERE rt.receivables_trx_id = (
2224: SELECT rma.claim_receivables_trx_id
2225: FROM ar_receipt_method_accounts rma, ar_cash_receipts cr
2226: WHERE rma.receipt_method_id = cr.receipt_method_id