DBA Data[Home] [Help]

APPS.LNS_FINANCIALS dependencies on LNS_FEE_SCHEDULES

Line 9082: from lns_fee_schedules sched

9078: l_rate_details LNS_FINANCIALS.INTEREST_RATE_REC;
9079:
9080: cursor c_additional_fees(p_loan_id number, p_phase varchar2, p_installment number) is
9081: select nvl(sum(sched.fee_amount), 0)
9082: from lns_fee_schedules sched
9083: ,lns_fees fees
9084: where sched.loan_id = p_loan_id
9085: and sched.fee_id = fees.fee_id
9086: and sched.active_flag = 'Y'