APPS.LNS_FEE_ENGINE dependencies on LNS_FEE_ASSIGNMENTS

Line 136: from lns_fee_assignments ass

132: ,fee.fee_description
133: ,ass.fee_basis
134: ,nvl(ass.begin_installment_number, 0) -- fix for bug 8928398
135: ,nvl(ass.phase, 'TERM')
136: from lns_fee_assignments ass
137: ,lns_disb_headers head
138: ,lns_fees_all fee
139: where ass.loan_id is null
140: and ass.disb_header_id = head.disb_header_id

Line 149: from lns_fee_assignments ass

145: select ass.fee_id
146: ,decode(ass.rate_type, 'FIXED', nvl(ass.fee,fee.fee), 'VARIABLE', nvl(ass.fee,fee.fee)/100)
147: ,fee.fee_description
148: ,ass.fee_basis
149: from lns_fee_assignments ass
150: ,lns_fees_all fee
151: where ass.fee_type = 'EVENT_CONVERSION'
152: and ass.fee_id = fee.fee_id
153: and loan_id = c_loan_id;

Line 718: from lns_fee_assignments assgn

714: ,nvl(fees.fee_waivable_flag,'N')
715: ,assgn.disb_header_id
716: ,nvl(assgn.phase, 'TERM')
717: ,nvl(assgn.CUSTOM_PROCEDURE, fees.CUSTOM_PROCEDURE)
718: from lns_fee_assignments assgn
719: ,lns_fees_all fees
720: where assgn.loan_id = nvl(p_loan_id, assgn.loan_id)
721: and assgn.fee_id = fees.fee_id
722: and nvl(trunc(assgn.end_date_active), trunc(sysdate) + 1) >= trunc(sysdate)

Line 891: from lns_fee_assignments assgn

887: ,dh.disb_header_id
888: ,dh.target_date
889: ,dh.header_amount
890: ,nvl(assgn.phase, 'TERM')
891: from lns_fee_assignments assgn
892: ,lns_fees_all fees
893: ,lns_disb_headers dh
894: where dh.loan_id = nvl(p_loan_id, dh.loan_id)
895: and dh.disb_header_id = nvl(p_disb_header_id, dh.disb_header_id)

Line 1004: from lns_fee_assignments

1000: where disb_header_id = p_disb_header_id;
1001:
1002: cursor c_from_installment(c_fee_id number, c_disb_header_id number, c_phase varchar2) is
1003: select nvl(BEGIN_INSTALLMENT_NUMBER,0)
1004: from lns_fee_assignments
1005: where fee_id = c_fee_id
1006: and disb_header_id = c_disb_header_id
1007: and nvl(phase, 'TERM') = c_phase;
1008:

Line 1057: -- FROM LNS_FEE_ASSIGNMENTS

1053: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - orig_loan ' || l_original_loan_amount);
1054:
1055: IF l_orig_fee_structures.count = 0 THEN
1056: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT
1057: -- FROM LNS_FEE_ASSIGNMENTS
1058: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');
1059: l_orig_fee_structures := getFeeStructures(p_fee_id => p_fee_id);
1060: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_orig_fee_structures.count);
1061:

Line 1163: from lns_fee_assignments

1159: l_based_on_terms varchar2(30);
1160:
1161: cursor c_from_installment(c_fee_id number, c_loan_id number, c_phase varchar2) is
1162: select nvl(BEGIN_INSTALLMENT_NUMBER,0)
1163: from lns_fee_assignments
1164: where fee_id = c_fee_id
1165: and loan_id = c_loan_id
1166: and nvl(phase, 'TERM') = c_phase;
1167:

Line 1197: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT LNS_FEE_ASSIGNMENTS

1193: ,p_fee_id => p_fee_id);
1194: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);
1195:
1196: if l_fee_structures.count = 0 then
1197: -- this fee has not yet been assigned to the loan, we need to get the fee structure from LNS_FEES, NOT LNS_FEE_ASSIGNMENTS
1198: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - fee is unassigned ');
1199: l_fee_structures := getFeeStructures(p_fee_id => p_fee_id);
1200: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - structs ' || l_fee_structures.count);
1201: l_installment := l_fee_structures(1).fee_from_installment;

Line 3228: --' ,lns_fee_assignments assign ' ||

3224: l_api_name := 'getFeesTotal';
3225:
3226: vPLSQL := 'SELECT decode(:p_waived_flag, ''Y'', nvl(sum(sched.waived_amount),0), nvl(sum(sched.fee_amount) - sum(sched.waived_amount),0))' ||
3227: ' from lns_fee_schedules sched ' ||
3228: --' ,lns_fee_assignments assign ' ||
3229: --' where assgn.fee_id = sched.fee_id ' ||
3230: ' Where sched.loan_id = :p_loan_id ' ||
3231: ' and sched.billed_flag = :p_billed_flag ' ||
3232: ' and sched.active_flag = ''Y'' ';

Line 4009: UPDATE lns_fee_assignments

4005: IF (l_inst_no IS NULL OR l_inst_no = -1) THEN
4006: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Call to LNS_FIN_UTIL.getNextInstForDisbursement failed');
4007: ELSE
4008:
4009: UPDATE lns_fee_assignments
4010: SET begin_installment_number = l_inst_no
4011: ,end_installment_number = l_inst_no
4012: ,object_version_number = object_version_number + 1
4013: ,last_updated_by = LNS_UTILITY_PUB.last_updated_by