APPS.LNS_BILLING_UTIL_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 74: from LNS_AMORTIZATION_SCHEDS am,

70: +-----------------------------------------------------------------------*/
71: /*
72: CURSOR get_data_crs(P_LOAN_ID NUMBER) IS
73: select nvl(max(am.PAYMENT_NUMBER), 0)
74: from LNS_AMORTIZATION_SCHEDS am,
75: lns_loan_headers head
76: where am.LOAN_ID = P_LOAN_ID and
77: am.LOAN_ID = head.LOAN_ID
78: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 136: from LNS_AMORTIZATION_SCHEDS am,

132: +-----------------------------------------------------------------------*/
133:
134: CURSOR get_data_crs(P_LOAN_ID NUMBER, P_PHASE VARCHAR2) IS
135: select nvl(max(am.PAYMENT_NUMBER), 0)
136: from LNS_AMORTIZATION_SCHEDS am,
137: lns_loan_headers head
138: where am.LOAN_ID = P_LOAN_ID
139: and am.LOAN_ID = head.LOAN_ID
140: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 199: from LNS_AMORTIZATION_SCHEDS am,

195: +-----------------------------------------------------------------------*/
196:
197: CURSOR get_data_crs(P_LOAN_ID NUMBER) IS
198: select nvl(max(am.PAYMENT_NUMBER), -1)
199: from LNS_AMORTIZATION_SCHEDS am,
200: lns_loan_headers head
201: where am.LOAN_ID = P_LOAN_ID and
202: am.LOAN_ID = head.LOAN_ID
203: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 263: from LNS_AMORTIZATION_SCHEDS am,

259: +-----------------------------------------------------------------------*/
260:
261: CURSOR get_data_crs(P_LOAN_ID NUMBER) IS
262: select nvl(max(am.PAYMENT_NUMBER), -1)
263: from LNS_AMORTIZATION_SCHEDS am,
264: lns_loan_headers head
265: where am.LOAN_ID = P_LOAN_ID and
266: am.LOAN_ID = head.LOAN_ID
267: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 342: from LNS_AMORTIZATION_SCHEDS am,

338: +-----------------------------------------------------------------------*/
339:
340: CURSOR get_data_crs(P_LOAN_ID NUMBER) IS
341: select nvl(max(am.PAYMENT_NUMBER), -1)
342: from LNS_AMORTIZATION_SCHEDS am,
343: lns_loan_headers head
344: where am.LOAN_ID = P_LOAN_ID and
345: am.LOAN_ID = head.LOAN_ID
346: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 375: from LNS_AMORTIZATION_SCHEDS

371: +-----------------------------------------------------------------------*/
372:
373: CURSOR get_data_crs(P_LOAN_ID NUMBER, P_PHASE VARCHAR2) IS
374: select nvl(max(PAYMENT_NUMBER), -1)
375: from LNS_AMORTIZATION_SCHEDS
376: where LOAN_ID = P_LOAN_ID
377: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
378: and REAMORTIZATION_AMOUNT is null
379: and nvl(PHASE, 'TERM') = nvl(P_PHASE, 'TERM');

Line 432: from LNS_AMORTIZATION_SCHEDS am,

428: +-----------------------------------------------------------------------*/
429:
430: CURSOR get_data_crs(P_LOAN_ID NUMBER) IS
431: select nvl(max(am.AMORTIZATION_SCHEDULE_ID), -1)
432: from LNS_AMORTIZATION_SCHEDS am,
433: lns_loan_headers head
434: where am.LOAN_ID = P_LOAN_ID
435: and am.LOAN_ID = head.LOAN_ID
436: and am.PAYMENT_NUMBER = LAST_PAYMENT_NUMBER(am.LOAN_ID)

Line 904: from LNS_AMORTIZATION_SCHEDS am,

900: +-----------------------------------------------------------------------*/
901:
902: CURSOR get_data_crs(P_LOAN_ID NUMBER, P_PHASE VARCHAR2) IS
903: select trunc(max(DUE_DATE))
904: from LNS_AMORTIZATION_SCHEDS am,
905: lns_loan_headers head
906: where am.LOAN_ID = P_LOAN_ID
907: and am.LOAN_ID = head.LOAN_ID
908: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 970: LNS_AMORTIZATION_SCHEDS am

966: select loan.funded_amount -
967: (select nvl(sum(rec.amount_applied), 0)
968: from
969: ar_receivable_applications_all rec,
970: LNS_AMORTIZATION_SCHEDS am
971: where
972: rec.application_type = 'CASH' and
973: trunc(rec.apply_date) <= trunc(P_DATE) and
974: rec.APPLIED_CUSTOMER_TRX_ID = am.principal_trx_id and

Line 1046: LNS_AMORTIZATION_SCHEDS am

1042: ELSE
1043: LnsLoanHeaderEO.FUNDED_AMOUNT -
1044: (select nvl(SUM(abs(nvl(psa_prin.AMOUNT_APPLIED, 0))) - SUM(nvl(psa_prin.AMOUNT_ADJUSTED, 0)) + SUM(abs(nvl(psa_prin.AMOUNT_CREDITED, 0))), 0)
1045: from
1046: LNS_AMORTIZATION_SCHEDS am
1047: ,ar_payment_schedules_all psa_prin
1048: where
1049: am.loan_id = LnsLoanHeaderEO.loan_id
1050: and am.PHASE = LnsLoanHeaderEO.CURRENT_PHASE

Line 1137: FROM lns_amortization_scheds

1133: | Cursor Declarations |
1134: +-----------------------------------------------------------------------*/
1135: CURSOR get_data_crs(P_LOAN_ID IN NUMBER) IS
1136: SELECT trunc(max(DUE_DATE))
1137: FROM lns_amortization_scheds
1138: WHERE loan_id = p_loan_id
1139: AND (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
1140: AND REAMORTIZATION_AMOUNT is null
1141: AND nvl(phase, 'TERM') = 'TERM';