APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 1427: l_status lns_loan_headers_all.loan_status%TYPE;

1423:
1424: l_updatableFlag VARCHAR2(1);
1425: l_fees_category lns_fees_all.fee_category%TYPE;
1426: l_fee_type lns_fees_all.fee_type%TYPE;
1427: l_status lns_loan_headers_all.loan_status%TYPE;
1428: l_disb_status lns_disb_headers.status%TYPE;
1429:
1430: CURSOR c_fasgm_edit (c_loan_id NUMBER, c_fee_id NUMBER, c_disb_header_id NUMBER) IS
1431: SELECT 'X' FROM DUAL

Line 1480: lns_loan_headers_all hdr

1476: CURSOR c_loan_details (c_disb_header_id NUMBER) IS
1477: SELECT
1478: hdr.loan_status
1479: FROM
1480: lns_loan_headers_all hdr
1481: WHERE
1482: hdr.loan_id in (select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id);
1483:
1484: CURSOR c_disb_details (c_disb_header_id NUMBER) IS