APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_FEES

Line 846: FROM LNS_FEES LnsFees ,

842: LnsLoanProductLines.MANDATORY_FLAG,
843: NULL OPEN_PHASE_FLAG, -- We don't use this flag anywhere
844: NULL PHASE,
845: LnsFees.CUSTOM_PROCEDURE
846: FROM LNS_FEES LnsFees ,
847: LNS_LOAN_HEADERS LnsLoanHeaders ,
848: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
849:
850: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id

Line 1117: FROM LNS_FEES LnsFees ,

1113: LnsLoanProductLines.MANDATORY_FLAG,
1114: NULL OPEN_PHASE_FLAG,
1115: (select phase from lns_disb_headers where disb_header_id = c_disb_header_id) PHASE,
1116: LnsFees.CUSTOM_PROCEDURE
1117: FROM LNS_FEES LnsFees ,
1118: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
1119:
1120: WHERE LnsLoanProductLines.PARENT_PRODUCT_LINES_ID = c_loan_prod_line_id
1121: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'DISB_FEE'

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