APPS.LNS_INDEX_RATES_PUB dependencies on LNS_TERMS

Line 940: lns_terms term

936: decode(loan.CURRENT_PHASE, 'TERM', term.percent_increase_life, 'OPEN', term.open_percent_increase_life),
937: decode(loan.CURRENT_PHASE, 'TERM', term.floor_rate, 'OPEN', term.open_floor_rate),
938: decode(loan.CURRENT_PHASE, 'TERM', term.ceiling_rate, 'OPEN', term.open_ceiling_rate)
939: FROM lns_loan_headers loan,
940: lns_terms term
941: WHERE loan.loan_id = term.loan_id
942: AND term.rate_type = 'FLOATING'
943: AND loan.loan_status NOT IN ('PAIDOFF','REJECTED','DELETED')
944: AND nvl(indexRateId, term.index_rate_id) = term.index_rate_id;

Line 954: lns_terms term

950: FROM lns_int_rate_headers_vl hdr
951: WHERE (EXISTS
952: (SELECT null
953: FROM lns_loan_headers loan,
954: lns_terms term
955: WHERE loan.loan_id = term.loan_id
956: AND term.rate_type = 'FLOATING'
957: AND loan.loan_status NOT IN ('PAIDOFF','REJECTED','DELETED')
958: AND term.index_rate_id = hdr.interest_rate_id)

Line 1145: lns_terms term,

1141: decode(loan.CURRENT_PHASE, 'TERM', term.percent_increase_life, 'OPEN', term.open_percent_increase_life),
1142: decode(loan.CURRENT_PHASE, 'TERM', term.floor_rate, 'OPEN', term.open_floor_rate),
1143: decode(loan.CURRENT_PHASE, 'TERM', term.ceiling_rate, 'OPEN', term.open_ceiling_rate)
1144: FROM lns_loan_headers loan,
1145: lns_terms term,
1146: lns_int_rate_headers_vl hdr
1147: WHERE loan.loan_id = p_loan_id
1148: AND loan.loan_id = term.loan_id
1149: AND term.rate_type = 'FLOATING'