APPS.LNS_PAYOFF_PUB dependencies on AR_CASH_RECEIPTS

Line 132: from ar_cash_receipts

128: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
129:
130: cursor c_receipt_number(p_cash_receipt_id number) is
131: select receipt_number, currency_code
132: from ar_cash_receipts
133: where cash_receipt_id = p_cash_receipt_id;
134:
135: cursor c_loans_obj_vers(p_loan_id number) is
136: select OBJECT_VERSION_NUMBER

Line 168: ,ar_cash_receipts rac

164: ,lam.interest_trx_id -- get this in order to create new interest document
165: ,lam.principal_trx_id
166: ,lam.fee_trx_id
167: from ar_receivable_applications rap
168: ,ar_cash_receipts rac
169: ,lns_amortization_scheds lam
170: ,ar_payment_schedules trx
171: where rap.cash_receipt_id = rac.cash_receipt_id
172: and rap.applied_customer_trx_id = trx.customer_trx_id

Line 1365: from AR_CASH_RECEIPTS CR

1361: (select SUM(DECODE(app.status,'UNAPP',NVL(app.amount_applied,0),0)) amt from AR_RECEIVABLE_APPLICATIONS app where app.cash_receipt_id = CR.CASH_RECEIPT_ID) RECEIPT_CURRENCY_AMOUNT,
1362: CR.EXCHANGE_RATE_TYPE,
1363: CR.EXCHANGE_DATE,
1364: CR.EXCHANGE_RATE
1365: from AR_CASH_RECEIPTS CR
1366: where CR.cash_receipt_id = p_recpt_id;
1367:
1368: Cursor getLoanCurrencyConversion(p_loanId number) is
1369: select loan.loan_currency LOAN_CURRENCY_CODE