APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_AMORTIZATION_SCHEDS

Line 6672: lns_amortization_scheds am,

6668:
6669: cursor c_get_billed_amount(p_loan_id number, p_code_combination_id number, p_adj_date date) is
6670: select nvl(sum(dist.amount), 0)
6671: from lns_amortization_lines lines,
6672: lns_amortization_scheds am,
6673: RA_CUST_TRX_LINE_GL_DIST_ALL dist
6674: where am.loan_id = p_loan_id
6675: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')
6676: and am.REAMORTIZATION_AMOUNT is null

Line 8188: LNS_AMORTIZATION_SCHEDS amort

8184: CURSOR cur_last_bill_duel_date(c_loan_id NUMBER) IS
8185: SELECT
8186: to_char(max(amort.due_date),'YYYY-MM-DD')
8187: FROM
8188: LNS_AMORTIZATION_SCHEDS amort
8189: WHERE amort.loan_id = c_loan_id
8190: AND amort.reversed_flag = 'N';
8191:
8192: BEGIN

Line 8772: from lns_amortization_scheds

8768: decode(lnh.current_phase, 'TERM', lnh.loan_start_date, 'OPEN', lnh.open_loan_start_date),
8769: -1,
8770: decode(lnh.current_phase, 'TERM', lnh.loan_start_date, 'OPEN', lnh.open_loan_start_date),
8771: (select max(due_date)
8772: from lns_amortization_scheds
8773: where reversed_flag = 'N'
8774: and loan_id = lnh.loan_id
8775: and phase = lnh.current_phase)))
8776: FROM lns_loan_headers lnh

Line 9619: AND c_accrual_date >= NVL((select max(due_date) from LNS_AMORTIZATION_SCHEDS aschd

9615: LNS_LOAN_HEADERS head, LNS_SYSTEM_OPTIONS sysopt
9616: WHERE
9617: head.org_id = sysopt.org_id
9618: AND sysopt.set_of_books_id = nvl(C_LEDGER_ID, sysopt.set_of_books_id)
9619: AND c_accrual_date >= NVL((select max(due_date) from LNS_AMORTIZATION_SCHEDS aschd
9620: where aschd.loan_id = head.loan_id and aschd.reversed_flag = 'N')
9621: ,decode(head.current_phase, 'OPEN',head.open_loan_start_date, head.loan_start_date))
9622: AND head.loan_status in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
9623: AND head.loan_id = NVL(C_LOAN_ID, head.loan_id)