APPS.LNS_WORK_FLOW dependencies on LNS_LOOKUPS

Line 959: l_loan_class lns_lookups.meaning%TYPE;

955: l_loan_assigned_name jtf_rs_resource_extns.source_name%TYPE;
956: l_loan_assigned_user fnd_user.user_name%TYPE;
957: l_current_user fnd_user.user_name%TYPE;
958: l_borrower_name hz_parties.party_name%TYPE;
959: l_loan_class lns_lookups.meaning%TYPE;
960: l_loan_type lns_loan_types.loan_type_name%TYPE;
961: l_loan_purpose lns_lookups.meaning%TYPE;
962: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;
963: l_collateral_percent VARCHAR2(10);

Line 961: l_loan_purpose lns_lookups.meaning%TYPE;

957: l_current_user fnd_user.user_name%TYPE;
958: l_borrower_name hz_parties.party_name%TYPE;
959: l_loan_class lns_lookups.meaning%TYPE;
960: l_loan_type lns_loan_types.loan_type_name%TYPE;
961: l_loan_purpose lns_lookups.meaning%TYPE;
962: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE;
963: l_collateral_percent VARCHAR2(10);
964: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;
965: l_loan_formatted_amount VARCHAR2(30);

Line 1041: lns_lookups llktt,

1037: ,lprod.loan_product_name
1038: FROM lns_loan_headers_all_vl llh, hz_parties hp,
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,

Line 1042: lns_lookups llklc,

1038: FROM lns_loan_headers_all_vl llh, hz_parties hp,
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

Line 1044: lns_lookups llkp,

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
1048: AND llh.loan_assigned_to = res.resource_id

Line 1045: lns_lookups llkst,

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
1048: AND llh.loan_assigned_to = res.resource_id
1049: AND res.category = 'EMPLOYEE'