APPS.LNS_WORK_FLOW dependencies on LNS_LOAN_TYPES

Line 562: l_loan_type lns_loan_types.loan_type_name%TYPE;

558: l_loan_number lns_loan_headers_all.loan_number%TYPE;
559: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;
560: l_loan_description lns_loan_headers_all.loan_description%TYPE;
561: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
562: l_loan_type lns_loan_types.loan_type_name%TYPE;
563: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
564: l_current_user_id lns_loan_headers_all.created_by%TYPE;
565: l_loan_formatted_amount VARCHAR2(50);
566: l_loan_undisbursed_amount VARCHAR2(50);

Line 563: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

559: l_requested_amount lns_loan_headers_all.requested_amount%TYPE;
560: l_loan_description lns_loan_headers_all.loan_description%TYPE;
561: l_loan_class_code lns_loan_headers_all.loan_class_code%TYPE;
562: l_loan_type lns_loan_types.loan_type_name%TYPE;
563: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
564: l_current_user_id lns_loan_headers_all.created_by%TYPE;
565: l_loan_formatted_amount VARCHAR2(50);
566: l_loan_undisbursed_amount VARCHAR2(50);
567: l_function_name VARCHAR2(50);

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 960: l_loan_type lns_loan_types.loan_type_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);
964: l_loan_amount lns_pay_sum_v.total_principal_balance%TYPE;

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 1431: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;

1427: l_api_version CONSTANT NUMBER := 1.0;
1428: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1429: l_loan_number LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1430: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1431: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1432: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1433: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1434: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;
1435: l_return_status Varchar2(1);

Line 1432: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;

1428: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1429: l_loan_number LNS_LOAN_HEADERS_ALL.LOAN_NUMBER%TYPE;
1430: l_loan_class_code LNS_LOAN_HEADERS_ALL.LOAN_CLASS_CODE%TYPE;
1431: l_loan_type LNS_LOAN_TYPES.LOAN_TYPE_NAME%TYPE;
1432: l_loan_type_id LNS_LOAN_TYPES.LOAN_TYPE_ID%TYPE;
1433: l_current_user_id LNS_LOAN_HEADERS_ALL.CREATED_BY%TYPE;
1434: l_event_name LNS_EVENTS.EVENT_NAME%TYPE;
1435: l_return_status Varchar2(1);
1436: l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE;

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