APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_RATE_SCHEDULES

Line 3310: 'lns_rate_schedules rate_sched1, ' ||

3306: 'lns_lookups rate_freq, ' ||
3307: 'lns_lookups pay_freq, ' ||
3308: 'fnd_lookups open_to_term, ' ||
3309: 'lns_loan_products_vl product, ' ||
3310: 'lns_rate_schedules rate_sched1, ' ||
3311: 'lns_rate_schedules rate_sched2 ' ||
3312:
3313: 'WHERE party.party_id = loan.primary_borrower_id and ' ||
3314: 'org.organization_id = loan.org_id and ' ||

Line 3311: 'lns_rate_schedules rate_sched2 ' ||

3307: 'lns_lookups pay_freq, ' ||
3308: 'fnd_lookups open_to_term, ' ||
3309: 'lns_loan_products_vl product, ' ||
3310: 'lns_rate_schedules rate_sched1, ' ||
3311: 'lns_rate_schedules rate_sched2 ' ||
3312:
3313: 'WHERE party.party_id = loan.primary_borrower_id and ' ||
3314: 'org.organization_id = loan.org_id and ' ||
3315: 'org.language = userenv(''LANG'') and ' ||

Line 3578: from lns_rate_schedules rs

3574: where LOAN_ID = P_LOAN_ID;
3575:
3576: cursor cur_floating(p_loan_id number, p_phase varchar2, p_installment number) is
3577: select nvl(floating_flag, 'N')
3578: from lns_rate_schedules rs
3579: ,lns_terms t
3580: where t.loan_id = p_loan_id
3581: and t.term_id = rs.term_id
3582: and rs.end_date_active is null

Line 5273: | 06-16-2006 karamach Removed code that deleted the rate sch row from lns_rate_schedules

5269: | MODIFICATION HISTORY
5270: | Date Author Description of Changes
5271: | 01-01-2004 scherkas Created
5272: | 01-20-2006 raverma delete row from rate_scheds for variable rate loan
5273: | 06-16-2006 karamach Removed code that deleted the rate sch row from lns_rate_schedules
5274: | and added fix in LNS_FINANCIAL_B.pls floatingRatePostProcessing procedure to update existing row to fix bug5331888
5275: | 07-31-2006 karamach Added code to update active_flag to N in lns_fee_schedules for unbilled manual fees to fix bug5397345
5276: *=======================================================================*/
5277: PROCEDURE REVERSE_LAST_AMORTIZATION(