APPS.LNS_PAYOFF_PUB dependencies on LNS_BILLING_UTIL_PUB

Line 174: and lam.payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)

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
173: and trx.customer_trx_id = lam.interest_trx_id
174: and lam.payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)
175: and lam.reversed_flag = 'N'
176: and lam.reamortization_amount is null
177: and lam.parent_amortization_id is null
178: and lam.loan_id = p_loan_id

Line 302: l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);

298: -- build the header for the loan document(s) to be created
299: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Building Invoice header/lines');
300: l_bill_headers_tbl(1).HEADER_ID := 101;
301: l_bill_headers_tbl(1).LOAN_ID := p_loan_id;
302: l_bill_headers_tbl(1).ASSOC_PAYMENT_NUM := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
303: l_bill_headers_tbl(1).DUE_DATE := p_payoff_date;
304:
305: -- now build the lines for the loan document(s) to be created
306: for i in 1..l_payoff_tbl2.count

Line 463: and payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);

459: where loan_id = p_loan_id
460: and reamortization_amount is null
461: and parent_amortization_id is null
462: --and reversed_flag = 'N'
463: and payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
464:
465: end if;
466: b_recalculate_interest := false;
467: end if;

Line 874: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)

870: order by payment_number, line_type;
871:
872: cursor c_loanInfo(p_loan_id number) is
873: select loan_number
874: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)
875: from lns_loan_headers
876: where loan_id = p_loan_id;
877:
878: cursor c_lastInterestAmount(p_loan_id number)

Line 885: and payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);

881: from lns_amortization_scheds
882: where loan_id = p_loan_id
883: and reversed_flag <> 'Y'
884: and reamortization_amount is null
885: and payment_number = LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
886:
887: cursor c_fees(p_loan_id number)
888: is
889: select sched.fee_amount