APPS.LNS_WORK_FLOW dependencies on LNS_LOAN_TYPES_VL

Line 596: FROM lns_events le, lns_loan_headers_all_vl lh, lns_loan_types_vl lt

592: || ' ' || lh.loan_currency loan_undisbursed_amount
593: ,decode(lh.loan_class_code,'ERS','LNS_ERS_CONTEXT_HOMEPAGE_MENU',
594: 'LNS_LOAN_CONTEXT_HOMEPAGE_MENU') function_name
595: ,lh.last_updated_by current_user_id
596: FROM lns_events le, lns_loan_headers_all_vl lh, lns_loan_types_vl lt
597: WHERE lh.loan_class_code = le.loan_class_code
598: AND le.enabled_flag = 'Y'
599: AND le.event_name = p_event_name
600: AND lt.loan_type_id = lh.loan_type_id

Line 1043: lns_loan_types_vl llklt,

1039: jtf_rs_resource_extns res, fnd_user fnd,
1040: lns_payments_summary_v ps,
1041: lns_lookups llktt,
1042: lns_lookups llklc,
1043: lns_loan_types_vl llklt,
1044: lns_lookups llkp,
1045: lns_lookups llkst,
1046: lns_loan_products_all_vl lprod
1047: WHERE llh.primary_borrower_id = hp.party_id

Line 2461: from lns_loan_types_vl

2457: , LNS_UTILITY_PUB.LAST_UPDATED_BY
2458: , LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
2459: from lns_event_actions ea, lns_events ev,
2460: (select loan_class_code, loan_type_id
2461: from lns_loan_types_vl
2462: minus
2463: select ev.loan_class_code loan_class_code, ea.loan_type_id loan_type_id
2464: from lns_events ev, lns_event_actions ea
2465: where ea.event_id = ev.event_id