APPS.LNS_PAYOFF_PUB dependencies on LNS_LOAN_HEADERS

Line 137: from lns_loan_headers

133: where cash_receipt_id = p_cash_receipt_id;
134:
135: cursor c_loans_obj_vers(p_loan_id number) is
136: select OBJECT_VERSION_NUMBER
137: from lns_loan_headers
138: where loan_id = p_loan_id;
139:
140: CURSOR loans_cur (p_loan_id number) IS
141: select

Line 147: from LNS_LOAN_HEADERS head

143: ,nvl(head.exchange_rate, 1)
144: ,head.exchange_date
145: ,head.exchange_rate_type
146: ,head.current_phase
147: from LNS_LOAN_HEADERS head
148: where head.loan_id = p_loan_id and
149: head.loan_status in ('ACTIVE', 'DELINQUENT', 'DEFAULT');
150:
151: -- this cursor retrieves any applications to

Line 875: from lns_loan_headers

871:
872: cursor c_loanInfo(p_loan_id number) is
873: select loan_number
874: ,LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(p_loan_id)
875: from lns_loan_headers
876: where loan_id = p_loan_id;
877:
878: cursor c_lastInterestAmount(p_loan_id number)
879: is

Line 1370: from LNS_LOAN_HEADERS_ALL loan

1366: where CR.cash_receipt_id = p_recpt_id;
1367:
1368: Cursor getLoanCurrencyConversion(p_loanId number) is
1369: select loan.loan_currency LOAN_CURRENCY_CODE
1370: from LNS_LOAN_HEADERS_ALL loan
1371: where loan.loan_id = p_loanId;
1372:
1373: --receipt_currency_code varchar2(3);
1374: --loan_currency_code varchar2(3);

Line 1396: from lns_loan_headers lnh

1392: select lnh.exchange_rate_type
1393: ,lnh.exchange_rate
1394: ,lnh.exchange_date
1395: ,lnh.loan_currency
1396: from lns_loan_headers lnh
1397: where loan_id = p_loan_id;
1398:
1399: cursor c_sob_currency is
1400: SELECT sb.currency_code