APPS.LNS_BILLING_UTIL_PUB dependencies on LNS_LOAN_HEADERS

Line 55: lns_loan_headers head

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')
59: and am.PARENT_AMORTIZATION_ID is null

Line 117: lns_loan_headers head

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')
121: and am.PARENT_AMORTIZATION_ID is null

Line 178: lns_loan_headers head

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')
182: -- and am.PARENT_AMORTIZATION_ID is null

Line 239: lns_loan_headers head

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)
243: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 751: from lns_loan_headers_all loan

747: rec.org_id = loan.org_id and
748: am.loan_id = loan.loan_id and
749: am.principal_trx_id is not null and
750: nvl(am.PHASE, 'TERM') = nvl(loan.CURRENT_PHASE, 'TERM'))
751: from lns_loan_headers_all loan
752: where loan.loan_id = P_LOAN_ID;
753:
754: BEGIN
755: OPEN get_data_crs(P_LOAN_ID, P_DATE);