2585: and active_flag = 'Y';
2586:
2587: cursor c_conv_fees(p_loan_id number) is
2588: select nvl(sum(fee),0)
2589: from lns_fee_assignments
2590: where loan_id = p_loan_id
2591: and fee_type = 'EVENT_CONVERSION';
2592:
2593: -- get first billed installment number
3649: and active_flag = 'Y';
3650:
3651: cursor c_conv_fees(p_loan_id number) is
3652: select nvl(sum(fee),0)
3653: from lns_fee_assignments
3654: where loan_id = p_loan_id
3655: and fee_type = 'EVENT_CONVERSION';
3656:
3657: -- get last bill date
4657: --and billed_flag = 'N';
4658:
4659: cursor c_conv_fees(p_loan_id number) is
4660: select nvl(sum(fee),0)
4661: from lns_fee_assignments
4662: where loan_id = p_loan_id
4663: and fee_type = 'EVENT_CONVERSION';
4664:
4665: -- get last bill date