APPS.LNS_CUSTOM_PUB dependencies on LNS_BILLING_UTIL_PUB

Line 169: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);

165: -- loan is customized
166: l_skip_update := false;
167:
168: -- check to see if the loan has ever been billed
169: l_last_installment_billed := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id);
170: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - last installment ' || l_last_installment_billed);
171:
172: if l_last_installment_billed > 0 then
173: FND_MESSAGE.Set_Name('LNS', 'LNS_LOAN_ALREADY_BILLED');

Line 1603: ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id, 'TERM'), 0)

1599: ,h.funded_amount
1600: ,h.requested_amount
1601: ,lns_financials.getRemainingBalance(p_loan_id)
1602: ,trunc(h.loan_maturity_date)
1603: ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id, 'TERM'), 0)
1604: -- ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id), -1)
1605: ,decode(nvl(t.day_count_method, 'PERIODIC30_360'), 'PERIODIC30_360', '30/360', t.day_count_method)
1606: ,nvl(h.custom_payments_flag, 'N')
1607: ,h.loan_status

Line 1604: -- ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id), -1)

1600: ,h.requested_amount
1601: ,lns_financials.getRemainingBalance(p_loan_id)
1602: ,trunc(h.loan_maturity_date)
1603: ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id, 'TERM'), 0)
1604: -- ,decode(p_based_on_terms, 'CURRENT', LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT(p_loan_id), -1)
1605: ,decode(nvl(t.day_count_method, 'PERIODIC30_360'), 'PERIODIC30_360', '30/360', t.day_count_method)
1606: ,nvl(h.custom_payments_flag, 'N')
1607: ,h.loan_status
1608: ,h.loan_currency