APPS.FTP_IRC_ADI_MIGRATE dependencies on FTP_IRC_TS_PARAM_HIST

Line 63: UPDATE FTP_IRC_TS_PARAM_HIST SET

59:
60: FOR i in 1..l_mean_rev_tbl.COUNT LOOP
61: BEGIN
62: -- if present, update it
63: UPDATE FTP_IRC_TS_PARAM_HIST SET
64: MEAN_REVERSION_SPEED = l_mean_rev_tbl(i),
65: LONG_RUN_RATE = l_long_rr_tbl(i),
66: VOLATILITY_MERTON = l_vol_merton_tbl(i),
67: VOLATILITY_VASICEK = l_vol_vasicek_tbl(i)

Line 73: INSERT INTO FTP_IRC_TS_PARAM_HIST(EFFECTIVE_DATE,INTEREST_RATE_CODE,

69: INTEREST_RATE_CODE = p_int_rate_code;
70:
71: IF (SQL%ROWCOUNT = 0)
72: THEN
73: INSERT INTO FTP_IRC_TS_PARAM_HIST(EFFECTIVE_DATE,INTEREST_RATE_CODE,
74: MEAN_REVERSION_SPEED,LONG_RUN_RATE,VOLATILITY_MERTON,VOLATILITY_VASICEK,
75: RATE_DATA_SOURCE_CODE,IS_VALID_FLG,LAST_MODIFIED_DATE,CREATION_DATE,
76: CREATED_BY,LAST_UPDATED_BY,LAST_UPDATE_DATE)
77: VALUES(l_eff_date_tbl(i),p_int_rate_code,l_mean_rev_tbl(i),l_long_rr_tbl(i),