DBA Data[Home] [Help]

APPS.LNS_CUSTOM_PUB dependencies on LNS_FEES

Line 307: ,lns_fees struct

303: -- total fees on the schedule by installment
304: cursor c_fees(p_loan_id number, p_installment number) is
305: select nvl(sum(sched.fee_amount), 0)
306: from lns_fee_schedules sched
307: ,lns_fees struct
308: where sched.loan_id = p_loan_id
309: and sched.fee_id = struct.fee_id
310: and fee_installment = p_installment
311: and active_flag = 'Y';