APPS.LNS_WORK_FLOW dependencies on LNS_LOAN_PRODUCTS_ALL

Line 975: l_product_name LNS_LOAN_PRODUCTS_ALL.LOAN_PRODUCT_NAME%TYPE;

971: l_overdue_num lns_pay_sum_overdue_v.number_overdue_bills%TYPE;
972: l_event_action_id LNS_EVENT_ACTIONS.EVENT_ACTION_ID%TYPE;
973: l_org_id NUMBER;
974: l_user_id NUMBER;
975: l_product_name LNS_LOAN_PRODUCTS_ALL.LOAN_PRODUCT_NAME%TYPE;
976: l_loan_approval_agent_note JTF_NOTES_TL.NOTES%TYPE;
977:
978:
979: /*-----------------------------------------------------------------------+

Line 1046: lns_loan_products_all_vl lprod

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'
1050: AND fnd.user_id = res.user_id

Line 1620: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;

1616: l_object_version_number NUMBER := 1;
1617: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1618: l_loan_approve_note VARCHAR2(2000);
1619: l_loan_approval_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
1620: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
1621: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
1622: l_action_id NUMBER;
1623: l_note_id NUMBER;
1624: l_MSG_DATA VARCHAR2(32767);

Line 1867: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;

1863: l_nid NUMBER;
1864: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
1865: l_loan_reject_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
1866: l_loan_reject_note VARCHAR2(2000);
1867: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
1868: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
1869: l_action_id NUMBER;
1870: l_note_id NUMBER;
1871: l_MSG_DATA VARCHAR2(32767);

Line 2104: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;

2100: l_nid NUMBER;
2101: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
2102: l_req_loan_info_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
2103: l_req_loan_info_note VARCHAR2(2000);
2104: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
2105: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
2106: l_action_id NUMBER;
2107: l_note_id NUMBER;
2108: l_MSG_DATA VARCHAR2(32767);

Line 3248: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;

3244: l_object_version_number NUMBER := 1;
3245: l_loan_id LNS_LOAN_HEADERS_ALL.LOAN_ID%TYPE;
3246: l_loan_approve_note VARCHAR2(2000);
3247: l_loan_approval_action_rec LNS_APPROVAL_ACTION_PUB.APPROVAL_ACTION_REC_TYPE;
3248: l_RETURN_STATUS LNS_LOAN_PRODUCTS_ALL.LOAN_APPR_REQ_FLAG%TYPE;
3249: G_JTF_NOTE_CONTEXTS_TAB JTF_NOTES_PUB.JTF_NOTE_CONTEXTS_TBL_TYPE;
3250: l_action_id NUMBER;
3251: l_note_id NUMBER;
3252: l_MSG_DATA VARCHAR2(32767);