DBA Data[Home] [Help]

APPS.LNS_FINANCIALS dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 5146: RA_CUSTOMER_TRX_LINES_ALL trx_lines

5142: -- get sum of all add int for last billed installment
5143: cursor c_add_int(p_loan_id number, p_amortization_schedule_id number) is
5144: select nvl(sum(am_lines.amount), 0)
5145: from lns_amortization_lines am_lines,
5146: RA_CUSTOMER_TRX_LINES_ALL trx_lines
5147: where am_lines.loan_id = p_loan_id
5148: and am_lines.amortization_schedule_id = p_amortization_schedule_id
5149: and am_lines.line_type = 'INT'
5150: and am_lines.cust_trx_line_id = trx_lines.CUSTOMER_TRX_LINE_ID