APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_FEES_ALL

Line 1425: l_fees_category lns_fees_all.fee_category%TYPE;

1421: ,p_disb_header_id in NUMBER
1422: ) return VARCHAR2 IS
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:

Line 1426: l_fee_type lns_fees_all.fee_type%TYPE;

1422: ) return VARCHAR2 IS
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

Line 1472: lns_fees_all fees

1468: CURSOR c_fee_details (c_fee_id NUMBER) IS
1469: SELECT
1470: fees.fee_category, fees.fee_type
1471: FROM
1472: lns_fees_all fees
1473: WHERE
1474: fees.fee_id = c_fee_id;
1475:
1476: CURSOR c_loan_details (c_disb_header_id NUMBER) IS