APPS.LNS_WORK_FLOW dependencies on LNS_LOOKUPS

Line 669: l_loan_class lns_lookups.meaning%TYPE;

665: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
666: l_loan_assigned_user fnd_user.user_name%TYPE;
667: l_current_user fnd_user.user_name%TYPE;
668: l_borrower_name hz_parties.party_name%TYPE;
669: l_loan_class lns_lookups.meaning%TYPE;
670: l_loan_type lns_loan_types.loan_type_name%TYPE;
671: l_loan_purpose lns_lookups.meaning%TYPE;
672: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;
673: l_collateral_percent VARCHAR2(10);

Line 671: l_loan_purpose lns_lookups.meaning%TYPE;

667: l_current_user fnd_user.user_name%TYPE;
668: l_borrower_name hz_parties.party_name%TYPE;
669: l_loan_class lns_lookups.meaning%TYPE;
670: l_loan_type lns_loan_types.loan_type_name%TYPE;
671: l_loan_purpose lns_lookups.meaning%TYPE;
672: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;
673: l_collateral_percent VARCHAR2(10);
674: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;
675: l_loan_formatted_amount VARCHAR2(30);

Line 745: lns_lookups llktt,

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,
747: lns_loan_types_vl llklt,
748: lns_lookups llkp,
749: lns_lookups llkst

Line 746: lns_lookups llklc,

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,
747: lns_loan_types_vl llklt,
748: lns_lookups llkp,
749: lns_lookups llkst
750: WHERE llh.primary_borrower_id = hp.party_id

Line 748: lns_lookups llkp,

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
752: AND res.category = 'EMPLOYEE'

Line 749: lns_lookups llkst

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
752: AND res.category = 'EMPLOYEE'
753: AND fnd.user_id = res.user_id