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 3451: 'to_char(LNS_FIN_UTILS.getActiveRate(loan.loan_id)) current_interest_rate, ' ||

3447: 'org.name operating_unit, ' ||
3448: 'loan_type.loan_type_name loan_type, ' ||
3449: 'loan_class.meaning loan_class, ' ||
3450: 'loan.loan_term || '' '' || periodlkup.meaning loan_term, ' ||
3451: 'to_char(LNS_FIN_UTILS.getActiveRate(loan.loan_id)) current_interest_rate, ' ||
3452: 'to_char(loan.loan_maturity_date, ''YYYY-MM-DD'') loan_maturity_date, ' ||
3453: 'to_char(PAY_SUM.total_principal_balance, :CURRENCY_FORMAT5) f_remaining_balance_amount, ' ||
3454: 'to_char(PAY_SUM.principal_paid_todate, :CURRENCY_FORMAT6) f_principal_paid_todate, ' ||
3455: 'to_char(PAY_SUM.interest_paid_todate, :CURRENCY_FORMAT7) f_interest_paid_todate, ' ||

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

3478: 'to_char(PAY_SUM_OVERDUE.last_overdue_date, ''YYYY-MM-DD'') last_overdue_date, ' ||
3479: 'to_char(PAY_SUM_OVERDUE.last_payment_amount, :CURRENCY_FORMAT17) f_last_payment_amount, ' ||
3480: 'PAY_SUM_OVERDUE.last_payment_amount last_payment_amount, ' ||
3481: 'to_char(PAY_SUM_OVERDUE.last_payment_date, ''YYYY-MM-DD'') last_payment_date, ' ||
3482: '(LNS_FIN_UTILS.getNumberInstallments(loan.loan_id, nvl(loan.current_phase, ''TERM'')) - PAY_SUM.next_payment_number) remaining_number_of_payments, ' ||
3483: 'contact_person.party_name PRIMARY_LOAN_CONTACT, ' ||
3484: 'loan.LOAN_CURRENCY LOAN_CURRENCY_CODE, ' ||
3485: 'curr.name LOAN_CURRENCY_MEANING, ' ||
3486: 'loan_subtype.meaning loan_subtype, ' ||

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

5350: from LNS_LOAN_HEADERS_VL head,
5351: LNS_TERMS term
5352: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
5353: and head.loan_id = term.loan_id
5354: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))
5355: and (head.BILLED_FLAG is null or head.BILLED_FLAG = 'N')
5356: and head.LOAN_TYPE_ID = nvl(P_TYPE_ID, head.LOAN_TYPE_ID)
5357: and nvl(head.PRODUCT_ID, -1) = nvl(P_PRODUCT_ID, nvl(head.PRODUCT_ID, -1)) -- fix for bug 14153250
5358: and head.PRIMARY_BORROWER_ID = nvl(P_BORROWER_ID, head.PRIMARY_BORROWER_ID)

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

5739: LNS_TERMS term
5740: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
5741: and head.loan_id = term.loan_id
5742: and (head.BILLED_FLAG = 'Y' or head.BILLED_FLAG is null) -- scherkas; fix for bug 5687852
5743: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))
5744: 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)
5745: ORDER BY head.LOAN_ID;
5746:
5747: BEGIN