APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_AMORTIZATION_LINES

Line 6671: from lns_amortization_lines lines,

6667: and lines.status(+) = 'APPROVED';
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')