APPS.LNS_PAYOFF_PUB dependencies on LNS_FEES

Line 188: ,lns_fees fees

184: select sched.fee_amount
185: ,fees.fee_name
186: ,sched.fee_installment
187: from lns_fee_schedules sched
188: ,lns_fees fees
189: where sched.loan_id = p_loan_id
190: and sched.fee_id = fees.fee_id
191: and sched.active_flag = 'Y'
192: and sched.billed_flag = 'N';

Line 893: ,lns_fees fees

889: select sched.fee_amount
890: ,fees.fee_name
891: ,sched.fee_installment
892: from lns_fee_schedules sched
893: ,lns_fees fees
894: where sched.loan_id = p_loan_id
895: and sched.fee_id = fees.fee_id
896: and sched.active_flag = 'Y'
897: and sched.billed_flag = 'N';