DBA Data[Home] [Help]

APPS.LNS_DISTRIBUTIONS_PUB dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 6673: RA_CUST_TRX_LINE_GL_DIST_ALL dist

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
6677: and am.loan_id = lines.loan_id