APPS.LNS_WORK_FLOW dependencies on LNS_PAY_SUM_OVERDUE_V

Line 681: l_overdue_num lns_pay_sum_overdue_v.number_overdue_bills%TYPE;

677: l_term VARCHAR2(15);
678: l_loan_maturity_date lns_loan_headers_all.loan_maturity_date%TYPE;
679: l_interest_rate VARCHAR2(30);
680: l_overdue_amount VARCHAR2(30);
681: l_overdue_num lns_pay_sum_overdue_v.number_overdue_bills%TYPE;
682: l_event_action_id LNS_EVENT_ACTIONS.EVENT_ACTION_ID%TYPE;
683: l_org_id NUMBER;
684: l_user_id NUMBER;
685:

Line 784: ,lns_pay_sum_overdue_v ps

780: FND_CURRENCY.SAFE_GET_FORMAT_MASK(llh.LOAN_CURRENCY,50))
781: || ' ' || llh.loan_currency overdue_amount
782: ,ps.number_overdue_bills overdue_num
783: FROM lns_loan_headers_all llh
784: ,lns_pay_sum_overdue_v ps
785: WHERE llh.loan_id = p_loan_id
786: AND ps.loan_id = llh.loan_id;
787:
788: BEGIN