APPS.LNS_WORK_FLOW dependencies on LNS_PAY_SUM_OVERDUE_V

Line 971: l_overdue_num lns_pay_sum_overdue_v.number_overdue_bills%TYPE;

967: l_term VARCHAR2(15);
968: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;
969: l_interest_rate VARCHAR2(30);
970: l_overdue_amount VARCHAR2(30);
971: l_overdue_num lns_pay_sum_overdue_v.number_overdue_bills%TYPE;
972: l_event_action_id LNS_EVENT_ACTIONS.EVENT_ACTION_ID%TYPE;
973: l_org_id NUMBER;
974: l_user_id NUMBER;
975: l_product_name LNS_LOAN_PRODUCTS_ALL.LOAN_PRODUCT_NAME%TYPE;

Line 1083: ,lns_pay_sum_overdue_v ps

1079: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
1080: || ' ' || llh.loan_currency overdue_amount
1081: ,ps.number_overdue_bills overdue_num
1082: FROM lns_loan_headers_all llh
1083: ,lns_pay_sum_overdue_v ps
1084: WHERE llh.loan_id = p_loan_id
1085: AND ps.loan_id = llh.loan_id;
1086:
1087: /* The below query will not work in case of multiple req for info and situations where user might