[Home] [Help]
125: select ass.fee_id
126: ,decode(ass.rate_type, 'FIXED', fee.fee, 'VARIABLE', fee.fee/100 * head.header_amount)
127: ,fee.fee_description
128: ,ass.fee_basis
129: from lns_fee_assignments ass
130: ,lns_disb_headers head
131: ,lns_fees_all fee
132: where ass.loan_id is null
133: and ass.disb_header_id = head.disb_header_id
138: select ass.fee_id
139: ,decode(ass.rate_type, 'FIXED', fee.fee, 'VARIABLE', fee.fee/100)
140: ,fee.fee_description
141: ,ass.fee_basis
142: from lns_fee_assignments ass
143: ,lns_fees_all fee
144: where ass.fee_type = 'EVENT_CONVERSION'
145: and loan_id = p_loan_id;
146:
724: ,nvl(assgn.begin_installment_number,0)
725: ,nvl(assgn.end_installment_number,0)
726: ,nvl(fees.fee_editable_flag,'N')
727: ,nvl(fees.fee_waivable_flag,'N')
728: from lns_fee_assignments assgn
729: ,lns_fees_all fees
730: where assgn.loan_id = nvl(p_loan_id, assgn.loan_id)
731: and assgn.fee_id = fees.fee_id
732: and nvl(trunc(assgn.end_date_active), trunc(sysdate) + 1) >= trunc(sysdate)
857: ,0
858: ,dh.disb_header_id
859: ,dh.target_date
860: ,dh.header_amount
861: from lns_fee_assignments assgn
862: ,lns_fees_all fees
863: ,lns_disb_headers dh
864: where dh.loan_id = nvl(p_loan_id, dh.loan_id)
865: and dh.disb_header_id = nvl(p_disb_header_id, dh.disb_header_id)
1007: l_fee_basis_tbl(1).fee_basis_amount := l_original_loan_amount;
1008: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - orig_loan ' || l_original_loan_amount);
1009:
1010: if l_orig_fee_structures.count = 0 then
1011: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT LNS_FEE_ASSIGNMENTS
1012: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');
1013: l_orig_fee_structures := getFeeStructures(p_fee_id => p_fee_id);
1014: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_orig_fee_structures.count);
1015: open c_disbAmount(p_disb_header_id);
1092: l_installment Number;
1093:
1094: cursor c_from_installment(p_fee_id number, p_loan_id number) is
1095: select nvl(BEGIN_INSTALLMENT_NUMBER,0)
1096: from lns_fee_assignments
1097: where fee_id = p_fee_id
1098: and loan_id = p_loan_id;
1099:
1100: begin
1110: ,p_fee_id => p_fee_id);
1111: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);
1112:
1113: if l_fee_structures.count = 0 then
1114: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT LNS_FEE_ASSIGNMENTS
1115: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');
1116: l_fee_structures := getFeeStructures(p_fee_id => p_fee_id);
1117: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);
1118: l_installment := l_fee_structures(1).fee_from_installment;
1624: ,fee.fee_name
1625: ,ass.fee
1626: ,fee.fee_category
1627: ,fee.fee_type
1628: from lns_fee_assignments ass
1629: ,lns_fees_all fee
1630: where ass.loan_id = p_loan_id
1631: and fee.fee_id = ass.fee_id
1632: and ass.fee_type = 'EVENT_CONVERSION';
2776: l_api_name := 'getFeesTotal';
2777:
2778: vPLSQL := 'SELECT decode(:p_waived_flag, ''Y'', nvl(sum(sched.waived_amount),0), nvl(sum(sched.fee_amount) - sum(sched.waived_amount),0))' ||
2779: ' from lns_fee_schedules sched ' ||
2780: --' ,lns_fee_assignments assign ' ||
2781: --' where assgn.fee_id = sched.fee_id ' ||
2782: ' Where sched.loan_id = :p_loan_id ' ||
2783: ' and sched.billed_flag = :p_billed_flag ' ||
2784: ' and sched.active_flag = ''Y'' ';
2912: vPlSql := 'select ' ||
2913: ' nvl(sum(amount_due_remaining),0) ' ||
2914: ' from lns_amortization_scheds am ' ||
2915: ' ,ar_payment_schedules ps ' ||
2916: ' ,lns_fee_assignments fass ' ||
2917: ' ,lns_fees fees ' ||
2918: ' where am.loan_id = :p_loan_id and ' ||
2919: ' am.payment_number = :p_installment and ' ||
2920: ' fees.fee_id = :p_fee_id and ' ||