eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_DISB_HEADERS

Line 1094: (decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id )) ,

1090: LnsFees.RATE_TYPE,
1091: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
1092: 'SUBMIT_FOR_APPROVAL',0,
1093: 'BILL_WITH_INSTALLMENT',1,
1094: (decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id )) ,
1095: -1 , 0 , LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id ))) + 1 )
1096: ) BEGIN_INSTALLMENT_NUMBER,
1097: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
1098: 'SUBMIT_FOR_APPROVAL',0,

Line 1095: -1 , 0 , LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id ))) + 1 )

1091: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
1092: 'SUBMIT_FOR_APPROVAL',0,
1093: 'BILL_WITH_INSTALLMENT',1,
1094: (decode(LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id )) ,
1095: -1 , 0 , LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id ))) + 1 )
1096: ) BEGIN_INSTALLMENT_NUMBER,
1097: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
1098: 'SUBMIT_FOR_APPROVAL',0,
1099: 'BILL_WITH_INSTALLMENT',1,

Line 1100: lns_fin_utils.getnumberinstallments((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id )) ) END_INSTALLMENT_NUMBER,

1096: ) BEGIN_INSTALLMENT_NUMBER,
1097: decode(LnsFees.BILLING_OPTION,'ORIGINATION',0,
1098: 'SUBMIT_FOR_APPROVAL',0,
1099: 'BILL_WITH_INSTALLMENT',1,
1100: lns_fin_utils.getnumberinstallments((select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id )) ) END_INSTALLMENT_NUMBER,
1101:
1102: NULL NUMBER_OF_PAYMENTS,
1103: LnsFees.BILLING_OPTION,
1104: NULL CREATED_BY,

Line 1115: (select phase from lns_disb_headers where disb_header_id = c_disb_header_id) PHASE,

1111: NULL END_DATE_ACTIVE,
1112: c_disb_header_id DISB_HEADER_ID,
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:

Line 1428: l_disb_status lns_disb_headers.status%TYPE;

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
1432: WHERE EXISTS ( SELECT NULL FROM LNS_FEE_ASSIGNMENTS fasgn

Line 1482: hdr.loan_id in (select loan_id from lns_disb_headers where disb_header_id = c_disb_header_id);

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
1485: SELECT
1486: disb.status

Line 1488: lns_disb_headers disb

1484: CURSOR c_disb_details (c_disb_header_id NUMBER) IS
1485: SELECT
1486: disb.status
1487: FROM
1488: lns_disb_headers disb
1489: WHERE
1490: disb.disb_header_id = c_disb_header_id;
1491:
1492: BEGIN