APPS.LNS_WORK_FLOW dependencies on LNS_LOAN_TYPES_VL

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

359: || ' ' || lh.loan_currency loan_undisbursed_amount
360: ,decode(lh.loan_class_code,'ERS','LNS_ERS_CONTEXT_HOMEPAGE_MENU',
361: 'LNS_LOAN_CONTEXT_HOMEPAGE_MENU') function_name
362: ,lh.last_updated_by current_user_id
363: FROM lns_events le, lns_loan_headers_all_vl lh, lns_loan_types_vl lt
364: WHERE lh.loan_class_code = le.loan_class_code
365: AND le.enabled_flag = 'Y'
366: AND le.event_name = p_event_name
367: AND lt.loan_type_id = lh.loan_type_id

Line 747: lns_loan_types_vl llklt,

743: jtf_rs_resource_extns res, fnd_user fnd,
744: lns_payments_summary_v ps,
745: lns_lookups llktt,
746: lns_lookups llklc,
747: lns_loan_types_vl llklt,
748: lns_lookups llkp,
749: lns_lookups llkst
750: WHERE llh.primary_borrower_id = hp.party_id
751: AND llh.loan_assigned_to = res.resource_id

Line 1150: from lns_loan_types_vl

1146: , LNS_UTILITY_PUB.LAST_UPDATED_BY
1147: , LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
1148: from lns_event_actions ea, lns_events ev,
1149: (select loan_class_code, loan_type_id
1150: from lns_loan_types_vl
1151: minus
1152: select ev.loan_class_code loan_class_code, ea.loan_type_id loan_type_id
1153: from lns_events ev, lns_event_actions ea
1154: where ea.event_id = ev.event_id