APPS.LNS_FINANCIALS dependencies on LNS_FEE_SCHEDULES

Line 588: from lns_fee_schedules sch,

584: -- bug # 4258345
585: -- add late fees to
586: cursor c_manual_fees(p_loan_id number, p_installment number) is
587: select sum(nvl(fee_amount,0))
588: from lns_fee_schedules sch,
589: lns_fees fees
590: where sch.active_flag = 'Y'
591: and sch.billed_flag = 'N'
592: and fees.fee_id = sch.fee_id

Line 637: from lns_fee_schedules sched

633:
634: -- get the sum of fees for a given loan for a given installment
635: cursor c_fees(p_loan_id number, p_installment number) is
636: select nvl(sum(sched.fee_amount), 0)
637: from lns_fee_schedules sched
638: ,lns_fees struct
639: where sched.loan_id = p_loan_id
640: and sched.fee_id = struct.fee_id
641: and struct.fee_type = 'EVENT_ORIGINATION'

Line 2579: from lns_fee_schedules sched

2575:
2576: -- total fees on the schedule by installment
2577: cursor c_fees(p_loan_id number, p_installment number) is
2578: select nvl(sum(sched.fee_amount), 0)
2579: from lns_fee_schedules sched
2580: ,lns_fees struct
2581: where sched.loan_id = p_loan_id
2582: and sched.fee_id = struct.fee_id
2583: and struct.fee_type = 'EVENT_ORIGINATION'

Line 3643: from lns_fee_schedules sched

3639:
3640: -- total fees on the schedule by installment
3641: cursor c_fees(p_loan_id number, p_installment number) is
3642: select nvl(sum(sched.fee_amount), 0)
3643: from lns_fee_schedules sched
3644: ,lns_fees struct
3645: where sched.loan_id = p_loan_id
3646: and sched.fee_id = struct.fee_id
3647: and struct.fee_type = 'EVENT_ORIGINATION'

Line 4650: from lns_fee_schedules sched

4646:
4647: -- total fees on the schedule by installment
4648: cursor c_fees(p_loan_id number, p_installment number) is
4649: select nvl(sum(sched.fee_amount), 0)
4650: from lns_fee_schedules sched
4651: ,lns_fees struct
4652: where sched.loan_id = p_loan_id
4653: and sched.fee_id = struct.fee_id
4654: and struct.fee_type = 'EVENT_ORIGINATION'

Line 5735: from lns_fee_schedules sched

5731:
5732: -- total fees on the schedule by installment
5733: cursor c_fees(p_loan_id number, p_installment number) is
5734: select nvl(sum(sched.fee_amount), 0)
5735: from lns_fee_schedules sched
5736: ,lns_fees struct
5737: where sched.loan_id = p_loan_id
5738: and sched.fee_id = struct.fee_id
5739: and fee_installment = p_installment

Line 6046: from lns_fee_schedules sched

6042:
6043: -- get the sum of fees for a given loan for a given installment
6044: cursor c_fees(p_loan_id number, p_installment number) is
6045: select nvl(sum(sched.fee_amount), 0)
6046: from lns_fee_schedules sched
6047: ,lns_fees struct
6048: where sched.loan_id = p_loan_id
6049: and sched.fee_id = struct.fee_id
6050: and fee_installment = p_installment

Line 6057: from lns_fee_schedules sch,

6053: -- bug # 4258345
6054: -- add late fees to
6055: cursor c_manual_fees(p_loan_id number, p_installment number) is
6056: select sum(nvl(fee_amount,0))
6057: from lns_fee_schedules sch,
6058: lns_fees fees
6059: where sch.active_flag = 'Y'
6060: and sch.billed_flag = 'N'
6061: and fees.fee_id = sch.fee_id

Line 8257: from lns_fee_schedules

8253: l_add_end_date date;
8254:
8255: cursor c_additional_fees(p_loan_id number) is
8256: select nvl(sum(fee_amount), 0)
8257: from lns_fee_schedules
8258: where loan_id = p_loan_id
8259: and billed_flag = 'N'
8260: and active_flag = 'Y';
8261: