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_WORK_FLOW dependencies on LNS_PAY_SUM_V

Line 674: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;

670: l_loan_type lns_loan_types.loan_type_name%TYPE;
671: l_loan_purpose lns_lookups.meaning%TYPE;
672: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;
673: l_collateral_percent VARCHAR2(10);
674: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;
675: l_loan_formatted_amount VARCHAR2(30);
676: l_loan_start_date lns_loan_headers_all.loan_start_date%TYPE;
677: l_term VARCHAR2(15);
678: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;

Line 775: ,lns_pay_sum_v ps

771: ELSE ps.total_principal_balance END),
772: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
773: || ' ' || llh.loan_currency loan_formatted_amount
774: FROM lns_loan_headers_all llh
775: ,lns_pay_sum_v ps
776: WHERE llh.loan_id = p_loan_id
777: AND ps.loan_id = llh.loan_id;
778: CURSOR csr_loan_details2 IS
779: SELECT to_char(ps.total_overdue,