DBA Data[Home] [Help]

APPS.LNS_PAYOFF_PUB dependencies on LNS_FEE_SCHEDULES

Line 187: from lns_fee_schedules sched

183: is
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'

Line 746: update lns_fee_schedules

742: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
743: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
744: RAISE FND_API.G_EXC_ERROR;
745:
746: update lns_fee_schedules
747: set billed_flag = 'Y'
748: where loan_id = p_loan_id
749: and active_flag = 'Y'
750: and billed_flag = 'N'

Line 892: from lns_fee_schedules sched

888: is
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'