APPS.LNS_EXT_LOAN_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 123: from lns_loan_headers_all

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:

Line 324: from lns_loan_headers_all loan,

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:

Line 783: | lns_loan_headers_all from lns_loan_extensions table

779: | PUBLIC PROCEDURE APPROVE_LOAN_EXTENSION
780: |
781: | DESCRIPTION
782: | This procedure approves loan extension and updates loan term data in
783: | lns_loan_headers_all from lns_loan_extensions table
784: |
785: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
786: | None
787: |

Line 889: lns_loan_headers_all loan,

885: loan.OBJECT_VERSION_NUMBER,
886: term.term_id,
887: nvl(loan.custom_payments_flag, 'N')
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;

Line 1200: | This procedure rejects loan extension. No changes is made in lns_loan_headers_all table

1196: /*========================================================================
1197: | PUBLIC PROCEDURE REJECT_LOAN_EXTENSION
1198: |
1199: | DESCRIPTION
1200: | This procedure rejects loan extension. No changes is made in lns_loan_headers_all table
1201: |
1202: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1203: | None
1204: |

Line 1432: from lns_loan_headers_all loan,

1428: trunc(nvl(term.prin_first_pay_date, term.first_payment_date)),
1429: nvl(term.prin_payment_frequency, term.loan_payment_frequency),
1430: decode(trunc(nvl(term.prin_first_pay_date, term.first_payment_date)) - trunc(loan.loan_start_date), 0, 'N', 'Y'),
1431: nvl(loan.custom_payments_flag, 'N')
1432: from lns_loan_headers_all loan,
1433: lns_terms term
1434: where loan.loan_id = P_LOAN_ID and
1435: loan.loan_id = term.loan_id;
1436: