eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_FIN_UTILS

Line 3186: 'to_char(LNS_FIN_UTILS.getActiveRate(loan.loan_id)) current_interest_rate, ' ||

3182: 'org.name operating_unit, ' ||
3183: 'loan_type.loan_type_name loan_type, ' ||
3184: 'loan_class.meaning loan_class, ' ||
3185: 'loan.loan_term || '' '' || periodlkup.meaning loan_term, ' ||
3186: 'to_char(LNS_FIN_UTILS.getActiveRate(loan.loan_id)) current_interest_rate, ' ||
3187: 'fnd_date.date_to_chardate(loan.loan_maturity_date) loan_maturity_date, ' ||
3188: 'to_char(payment_summary.total_principal_balance, :CURRENCY_FORMAT5) f_remaining_balance_amount, ' ||
3189: 'to_char(payment_summary.principal_paid_todate, :CURRENCY_FORMAT6) f_principal_paid_todate, ' ||
3190: 'to_char(payment_summary.interest_paid_todate, :CURRENCY_FORMAT7) f_interest_paid_todate, ' ||

Line 3217: '(LNS_FIN_UTILS.getNumberInstallments(loan.loan_id, nvl(loan.current_phase, ''TERM'')) - payment_summary.next_payment_number) remaining_number_of_payments, ' ||

3213: 'fnd_date.date_to_chardate(payment_summary.last_overdue_date) last_overdue_date, ' ||
3214: 'to_char(payment_summary.last_payment_amount, :CURRENCY_FORMAT17) f_last_payment_amount, ' ||
3215: 'payment_summary.last_payment_amount last_payment_amount, ' ||
3216: 'fnd_date.date_to_chardate(payment_summary.last_payment_date) last_payment_date, ' ||
3217: '(LNS_FIN_UTILS.getNumberInstallments(loan.loan_id, nvl(loan.current_phase, ''TERM'')) - payment_summary.next_payment_number) remaining_number_of_payments, ' ||
3218: 'contact_person.party_name PRIMARY_LOAN_CONTACT, ' ||
3219: 'loan.LOAN_CURRENCY LOAN_CURRENCY_CODE, ' ||
3220: 'curr.name LOAN_CURRENCY_MEANING, ' ||
3221: 'loan_subtype.meaning loan_subtype, ' ||

Line 4758: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))

4754: from LNS_LOAN_HEADERS head,
4755: LNS_TERMS term
4756: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
4757: and head.loan_id = term.loan_id
4758: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))
4759: and (head.BILLED_FLAG is null or head.BILLED_FLAG = 'N')
4760: and head.PRIMARY_BORROWER_ID = nvl(P_BORROWER_ID, head.PRIMARY_BORROWER_ID)
4761: and head.LOAN_ID = nvl(P_LOAN_ID, head.LOAN_ID)
4762: and (trunc(decode(head.CURRENT_PHASE, 'OPEN', term.OPEN_NEXT_PAYMENT_DATE, term.NEXT_PAYMENT_DUE_DATE)) - trunc(sysdate))

Line 5129: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))

5125: LNS_TERMS term
5126: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
5127: and head.loan_id = term.loan_id
5128: and (head.BILLED_FLAG = 'Y' or head.BILLED_FLAG is null) -- scherkas; fix for bug 5687852
5129: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))
5130: and trunc(decode(head.CURRENT_PHASE, 'OPEN', term.OPEN_NEXT_PAYMENT_DATE, term.NEXT_PAYMENT_DUE_DATE) + nvl(term.NUMBER_GRACE_DAYS, 0)) < trunc(sysdate)
5131: ORDER BY head.LOAN_ID;
5132:
5133: BEGIN