APPS.LNS_BILLING_UTIL_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 54: from LNS_AMORTIZATION_SCHEDS am,

50: +-----------------------------------------------------------------------*/
51: /*
52: CURSOR get_data_crs(P_LOAN_ID NUMBER) IS
53: select nvl(max(am.PAYMENT_NUMBER), 0)
54: from LNS_AMORTIZATION_SCHEDS am,
55: lns_loan_headers head
56: where am.LOAN_ID = P_LOAN_ID and
57: am.LOAN_ID = head.LOAN_ID
58: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 116: from LNS_AMORTIZATION_SCHEDS am,

112: +-----------------------------------------------------------------------*/
113:
114: CURSOR get_data_crs(P_LOAN_ID NUMBER, P_PHASE VARCHAR2) IS
115: select nvl(max(am.PAYMENT_NUMBER), 0)
116: from LNS_AMORTIZATION_SCHEDS am,
117: lns_loan_headers head
118: where am.LOAN_ID = P_LOAN_ID
119: and am.LOAN_ID = head.LOAN_ID
120: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 177: from LNS_AMORTIZATION_SCHEDS am,

173: +-----------------------------------------------------------------------*/
174:
175: CURSOR get_data_crs(P_LOAN_ID NUMBER) IS
176: select nvl(max(am.PAYMENT_NUMBER), -1)
177: from LNS_AMORTIZATION_SCHEDS am,
178: lns_loan_headers head
179: where am.LOAN_ID = P_LOAN_ID and
180: am.LOAN_ID = head.LOAN_ID
181: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 238: from LNS_AMORTIZATION_SCHEDS am,

234: +-----------------------------------------------------------------------*/
235:
236: CURSOR get_data_crs(P_LOAN_ID NUMBER) IS
237: select nvl(max(am.AMORTIZATION_SCHEDULE_ID), -1)
238: from LNS_AMORTIZATION_SCHEDS am,
239: lns_loan_headers head
240: where am.LOAN_ID = P_LOAN_ID
241: and am.LOAN_ID = head.LOAN_ID
242: and am.PAYMENT_NUMBER = LAST_PAYMENT_NUMBER(am.LOAN_ID)

Line 742: LNS_AMORTIZATION_SCHEDS am

738: select loan.funded_amount -
739: (select nvl(sum(rec.amount_applied), 0)
740: from
741: ar_receivable_applications_all rec,
742: LNS_AMORTIZATION_SCHEDS am
743: where
744: rec.application_type = 'CASH' and
745: trunc(rec.apply_date) <= trunc(P_DATE) and
746: rec.APPLIED_CUSTOMER_TRX_ID = am.principal_trx_id and