APPS.LNS_WORK_FLOW dependencies on LNS_PAY_SUM_V

Line 964: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;

960: l_loan_type lns_loan_types.loan_type_name%TYPE;
961: l_loan_purpose lns_lookups.meaning%TYPE;
962: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;
963: l_collateral_percent VARCHAR2(10);
964: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;
965: l_loan_formatted_amount VARCHAR2(30);
966: l_loan_start_date lns_loan_headers_all.loan_start_date%TYPE;
967: l_term VARCHAR2(15);
968: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;

Line 1073: ,lns_pay_sum_v ps

1069: ELSE ps.total_principal_balance END),
1070: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
1071: || ' ' || llh.loan_currency loan_formatted_amount
1072: FROM lns_loan_headers_all llh
1073: ,lns_pay_sum_v ps
1074: WHERE llh.loan_id = p_loan_id
1075: AND ps.loan_id = llh.loan_id;
1076:
1077: CURSOR csr_loan_details2 IS