eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTP_IRC_ADI_MIGRATE dependencies on FTP_IRC_RATE_TERMS

Line 215: l_int_term FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM%TYPE;

211: )
212: IS
213: l_select_stmt varchar2(1000);
214: l_curr_date DATE := NULL;
215: l_int_term FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM%TYPE;
216: l_int_mult FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM_MULT%TYPE;
217: l_indx NUMBER;
218:
219: TYPE t_int_rates_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.INTEREST_RATE1%TYPE;

Line 216: l_int_mult FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM_MULT%TYPE;

212: IS
213: l_select_stmt varchar2(1000);
214: l_curr_date DATE := NULL;
215: l_int_term FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM%TYPE;
216: l_int_mult FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM_MULT%TYPE;
217: l_indx NUMBER;
218:
219: TYPE t_int_rates_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.INTEREST_RATE1%TYPE;
220: TYPE t_int_terms_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM%TYPE;

Line 220: TYPE t_int_terms_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM%TYPE;

216: l_int_mult FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM_MULT%TYPE;
217: l_indx NUMBER;
218:
219: TYPE t_int_rates_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.INTEREST_RATE1%TYPE;
220: TYPE t_int_terms_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM%TYPE;
221: TYPE t_int_mults_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM_MULT%TYPE;
222: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.EFFECTIVE_DATE%TYPE;
223:
224: l_int_rates_tbl t_int_rates_tbl;

Line 221: TYPE t_int_mults_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM_MULT%TYPE;

217: l_indx NUMBER;
218:
219: TYPE t_int_rates_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.INTEREST_RATE1%TYPE;
220: TYPE t_int_terms_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM%TYPE;
221: TYPE t_int_mults_tbl IS TABLE OF FTP_IRC_RATE_TERMS.INTEREST_RATE_TERM_MULT%TYPE;
222: TYPE t_eff_date_tbl IS TABLE OF FTP_IRC_ADI_RATE_T.EFFECTIVE_DATE%TYPE;
223:
224: l_int_rates_tbl t_int_rates_tbl;
225: l_int_terms_tbl t_int_terms_tbl;

Line 241: from FTP_IRC_RATE_TERMS

237:
238: --Get the term and its multipliers
239: select INTEREST_RATE_TERM_MULT,INTEREST_RATE_TERM
240: bulk collect into l_int_mults_tbl,l_int_terms_tbl
241: from FTP_IRC_RATE_TERMS
242: where INTEREST_RATE_CODE = p_int_rate_code
243: --Bobby20050719 - UI sorts terms points based on actual length of the term - - Bug 4494361
244: order by INTEREST_RATE_TERM * decode(INTEREST_RATE_TERM_MULT,'D',1, 'M',30.5, 'Y',365);
245: