APPS.LNS_CUSTOM_PUB dependencies on LNS_FEE_SCHEDULES

Line 303: from lns_fee_schedules sched

299:
300: -- total fees on the schedule by installment
301: cursor c_fees(p_loan_id number, p_installment number) is
302: select nvl(sum(sched.fee_amount), 0)
303: from lns_fee_schedules sched
304: ,lns_fees struct
305: where sched.loan_id = p_loan_id
306: and sched.fee_id = struct.fee_id
307: and fee_installment = p_installment

Line 1975: from lns_fee_schedules sched

1971:
1972: -- total fees on the schedule by installment
1973: cursor c_fees(p_loan_id number, p_installment number) is
1974: select nvl(sum(sched.fee_amount), 0)
1975: from lns_fee_schedules sched
1976: ,lns_fees struct
1977: where sched.loan_id = p_loan_id
1978: and sched.fee_id = struct.fee_id
1979: and fee_installment = p_installment

Line 1985: from lns_fee_schedules sch,

1981:
1982: -- manual fees
1983: cursor c_manual_fees(p_loan_id number, p_installment number) is
1984: select sum(nvl(fee_amount,0))
1985: from lns_fee_schedules sch,
1986: lns_fees fees
1987: where sch.active_flag = 'Y'
1988: and sch.billed_flag = 'N'
1989: and fees.fee_id = sch.fee_id