APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_RATE_SCHEDULES

Line 3583: 'lns_rate_schedules rate_sched1, ' ||

3579: 'lns_lookups rate_freq, ' ||
3580: 'lns_lookups pay_freq, ' ||
3581: 'fnd_lookups open_to_term, ' ||
3582: 'lns_loan_products_vl product, ' ||
3583: 'lns_rate_schedules rate_sched1, ' ||
3584: 'lns_rate_schedules rate_sched2 ' ||
3585:
3586: 'WHERE party.party_id = loan.primary_borrower_id and ' ||
3587: 'org.organization_id = loan.org_id and ' ||

Line 3584: 'lns_rate_schedules rate_sched2 ' ||

3580: 'lns_lookups pay_freq, ' ||
3581: 'fnd_lookups open_to_term, ' ||
3582: 'lns_loan_products_vl product, ' ||
3583: 'lns_rate_schedules rate_sched1, ' ||
3584: 'lns_rate_schedules rate_sched2 ' ||
3585:
3586: 'WHERE party.party_id = loan.primary_borrower_id and ' ||
3587: 'org.organization_id = loan.org_id and ' ||
3588: 'org.language = userenv(''LANG'') and ' ||

Line 3900: from lns_rate_schedules rs

3896: where LOAN_ID = P_LOAN_ID;
3897: /*
3898: cursor cur_floating(p_loan_id number, p_phase varchar2, p_installment number) is
3899: select nvl(floating_flag, 'N')
3900: from lns_rate_schedules rs
3901: ,lns_terms t
3902: where t.loan_id = p_loan_id
3903: and t.term_id = rs.term_id
3904: and rs.end_date_active is null

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

5883: | MODIFICATION HISTORY
5884: | Date Author Description of Changes
5885: | 01-01-2004 scherkas Created
5886: | 01-20-2006 raverma delete row from rate_scheds for variable rate loan
5887: | 06-16-2006 karamach Removed code that deleted the rate sch row from lns_rate_schedules
5888: | and added fix in LNS_FINANCIAL_B.pls floatingRatePostProcessing procedure to update existing row to fix bug5331888
5889: | 07-31-2006 karamach Added code to update active_flag to N in lns_fee_schedules for unbilled manual fees to fix bug5397345
5890: *=======================================================================*/
5891: PROCEDURE REVERSE_LAST_AMORTIZATION(

Line 9825: and nvl(head.LAST_PAYMENT_NUMBER, 0) < (select max(END_INSTALLMENT_NUMBER) from lns_rate_schedules

9821: LNS_TERMS term
9822: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
9823: and head.loan_id = term.loan_id
9824: and (head.BILLED_FLAG = 'Y' or head.BILLED_FLAG is null)
9825: and nvl(head.LAST_PAYMENT_NUMBER, 0) < (select max(END_INSTALLMENT_NUMBER) from lns_rate_schedules
9826: where term_id = term.term_id and phase = nvl(head.CURRENT_PHASE, 'TERM'))
9827: and trunc(term.NEXT_PAYMENT_DUE_DATE + nvl(term.NUMBER_GRACE_DAYS, 0)) < trunc(sysdate)
9828: and head.LOAN_ID = P_LOAN_ID;
9829:

Line 9837: and nvl(head.LAST_PAYMENT_NUMBER, 0) < (select max(END_INSTALLMENT_NUMBER) from lns_rate_schedules

9833: LNS_TERMS term
9834: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
9835: and head.loan_id = term.loan_id
9836: and (head.BILLED_FLAG is null or head.BILLED_FLAG = 'N')
9837: and nvl(head.LAST_PAYMENT_NUMBER, 0) < (select max(END_INSTALLMENT_NUMBER) from lns_rate_schedules
9838: where term_id = term.term_id and phase = nvl(head.CURRENT_PHASE, 'TERM'))
9839: and head.LOAN_ID = P_LOAN_ID;
9840:
9841: BEGIN