DBA Data[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on LNS_LOAN_HEADERS_ALL_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 742: FROM lns_loan_headers_all_vl llh, hz_parties hp,

738: ,llh.loan_maturity_date
739: ,LNS_FINANCIALS.getActiveRate(llh.LOAN_ID) interest_rate
740: ,llkp.meaning loan_purpose
741: ,llh.org_id
742: FROM lns_loan_headers_all_vl llh, hz_parties hp,
743: jtf_rs_resource_extns res, fnd_user fnd,
744: lns_payments_summary_v ps,
745: lns_lookups llktt,
746: lns_lookups llklc,