119: where LOAN_EXT_ID = P_LOAN_EXT_ID;
120:
121: CURSOR loan_details_cur(P_LOAN_ID number) IS
122: select LOAN_STATUS, nvl(custom_payments_flag, 'N'), nvl(CURRENT_PHASE, 'TERM')
123: from lns_loan_headers_all
124: where loan_id = P_LOAN_ID;
125:
126: BEGIN
127:
320: where ext.LOAN_EXT_ID = P_LOAN_EXT_ID;
321:
322: CURSOR loan_details_cur(P_LOAN_EXT_ID number) IS
323: select loan.LOAN_STATUS, nvl(loan.custom_payments_flag, 'N'), nvl(loan.CURRENT_PHASE, 'TERM')
324: from lns_loan_headers_all loan,
325: lns_loan_extensions ext
326: where ext.LOAN_EXT_ID = P_LOAN_EXT_ID and
327: ext.loan_id = loan.loan_id;
328:
775: | PUBLIC PROCEDURE APPROVE_LOAN_EXTENSION
776: |
777: | DESCRIPTION
778: | This procedure approves loan extension and updates loan term data in
779: | lns_loan_headers_all from lns_loan_extensions table
780: |
781: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
782: | None
783: |
885: ext.DESCRIPTION,
886: ext.EXT_TERM,
887: ext.EXT_TERM_PERIOD
888: from lns_loan_extensions ext,
889: lns_loan_headers_all loan,
890: lns_terms term
891: where ext.LOAN_EXT_ID = P_LOAN_EXT_ID and
892: loan.LOAN_ID = ext.LOAN_ID and
893: term.loan_id = loan.LOAN_ID;
1188: /*========================================================================
1189: | PUBLIC PROCEDURE REJECT_LOAN_EXTENSION
1190: |
1191: | DESCRIPTION
1192: | This procedure rejects loan extension. No changes is made in lns_loan_headers_all table
1193: |
1194: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1195: | None
1196: |
1423: trunc(nvl(term.prin_first_pay_date, term.first_payment_date)),
1424: nvl(term.prin_payment_frequency, term.loan_payment_frequency),
1425: decode(trunc(nvl(term.prin_first_pay_date, term.first_payment_date)) - trunc(loan.loan_start_date), 0, 'N', 'Y'),
1426: nvl(loan.custom_payments_flag, 'N')
1427: from lns_loan_headers_all loan,
1428: lns_terms term
1429: where loan.loan_id = P_LOAN_ID and
1430: loan.loan_id = term.loan_id;
1431: