DBA Data[Home] [Help]

APPS.LNS_FINANCIALS dependencies on LNS_FEES

Line 9083: ,lns_fees fees

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'
9087: and sched.billed_flag = 'N'