APPS.FTP_IRC_ADI_MIGRATE dependencies on FTP_IRC_RATE_HIST

Line 315: UPDATE FTP_IRC_RATE_HIST SET

311:
312: l_int_term := l_int_terms_tbl(l_indx);
313: l_int_mult := l_int_mults_tbl(l_indx);
314: -- if present, update it
315: UPDATE FTP_IRC_RATE_HIST SET
316: INTEREST_RATE = l_int_rates_tbl(i)
317: where INTEREST_RATE_TERM = l_int_term and
318: INTEREST_RATE_TERM_MULT = l_int_mult and
319: EFFECTIVE_DATE = l_eff_date_tbl(i) and

Line 324: insert into FTP_IRC_RATE_HIST(EFFECTIVE_DATE,INTEREST_RATE_CODE,

320: INTEREST_RATE_CODE = p_int_rate_code;
321:
322: IF (SQL%ROWCOUNT = 0)
323: THEN
324: insert into FTP_IRC_RATE_HIST(EFFECTIVE_DATE,INTEREST_RATE_CODE,
325: INTEREST_RATE_TERM,INTEREST_RATE_TERM_MULT,INTEREST_RATE,
326: RATE_DATA_SOURCE_CODE,LAST_MODIFIED_DATE,CREATION_DATE,CREATED_BY,
327: LAST_UPDATED_BY,LAST_UPDATE_DATE )
328: values(l_eff_date_tbl(i),p_int_rate_code,l_int_term,