DBA Data[Home] [Help]

APPS.ARP_DEDUCTION dependencies on AR_RECEIVABLES_TRX

Line 2216: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;

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

Line 2226: FROM ar_receivables_trx rt

2222: END IF;
2223:
2224: SELECT rt.receivables_trx_id
2225: INTO l_receivables_trx_id
2226: FROM ar_receivables_trx rt
2227: WHERE rt.receivables_trx_id = (
2228: SELECT rma.claim_receivables_trx_id
2229: FROM ar_receipt_method_accounts rma, ar_cash_receipts cr
2230: WHERE rma.receipt_method_id = cr.receipt_method_id