APPS.LNS_BILLING_UTIL_PUB dependencies on LNS_FEE_SCHEDULES

Line 283: FROM lns_fee_schedules schd

279: l_zero_inst_count := 0;
280:
281: SELECT nvl(count(1),0)
282: INTO l_zero_inst_count
283: FROM lns_fee_schedules schd
284: ,lns_fees_all struct
285: ,lns_loan_headers_all loan
286: WHERE loan.loan_id = P_LOAN_ID
287: AND schd.loan_id = loan.loan_id