APPS.FII_SNAP_TBL_REFRESH dependencies on FII_TIME_API

Line 141: l_pp_this_date := FII_TIME_API.ent_sd_pper_end(l_this_date);

137: g_phase := 'Populate l_pp_this_date, l_pq_this_date, l_ly_this_date, l_this_date_gov';
138:
139: /* Commented out for bug 4899518 and replaced with select
140: /*
141: l_pp_this_date := FII_TIME_API.ent_sd_pper_end(l_this_date);
142: l_pq_this_date := FII_TIME_API.ent_sd_pqtr_end(l_this_date);
143: l_ly_this_date := FII_TIME_API.ent_sd_lyr_end(l_this_date);
144: l_this_date_gov := FII_TIME_API.ent_cper_end(l_this_date);
145: */

Line 142: l_pq_this_date := FII_TIME_API.ent_sd_pqtr_end(l_this_date);

138:
139: /* Commented out for bug 4899518 and replaced with select
140: /*
141: l_pp_this_date := FII_TIME_API.ent_sd_pper_end(l_this_date);
142: l_pq_this_date := FII_TIME_API.ent_sd_pqtr_end(l_this_date);
143: l_ly_this_date := FII_TIME_API.ent_sd_lyr_end(l_this_date);
144: l_this_date_gov := FII_TIME_API.ent_cper_end(l_this_date);
145: */
146:

Line 143: l_ly_this_date := FII_TIME_API.ent_sd_lyr_end(l_this_date);

139: /* Commented out for bug 4899518 and replaced with select
140: /*
141: l_pp_this_date := FII_TIME_API.ent_sd_pper_end(l_this_date);
142: l_pq_this_date := FII_TIME_API.ent_sd_pqtr_end(l_this_date);
143: l_ly_this_date := FII_TIME_API.ent_sd_lyr_end(l_this_date);
144: l_this_date_gov := FII_TIME_API.ent_cper_end(l_this_date);
145: */
146:
147: SELECT NVL(fii_time_api.ent_sd_pper_end(l_this_date),l_min_start_date),

Line 144: l_this_date_gov := FII_TIME_API.ent_cper_end(l_this_date);

140: /*
141: l_pp_this_date := FII_TIME_API.ent_sd_pper_end(l_this_date);
142: l_pq_this_date := FII_TIME_API.ent_sd_pqtr_end(l_this_date);
143: l_ly_this_date := FII_TIME_API.ent_sd_lyr_end(l_this_date);
144: l_this_date_gov := FII_TIME_API.ent_cper_end(l_this_date);
145: */
146:
147: SELECT NVL(fii_time_api.ent_sd_pper_end(l_this_date),l_min_start_date),
148: NVL(fii_time_api.ent_sd_pqtr_end(l_this_date),l_min_start_date),

Line 147: SELECT NVL(fii_time_api.ent_sd_pper_end(l_this_date),l_min_start_date),

143: l_ly_this_date := FII_TIME_API.ent_sd_lyr_end(l_this_date);
144: l_this_date_gov := FII_TIME_API.ent_cper_end(l_this_date);
145: */
146:
147: SELECT NVL(fii_time_api.ent_sd_pper_end(l_this_date),l_min_start_date),
148: NVL(fii_time_api.ent_sd_pqtr_end(l_this_date),l_min_start_date),
149: NVL(fii_time_api.ent_sd_lyr_end(l_this_date),l_min_start_date),
150: NVL( fii_time_api.ent_cper_end(l_this_date),l_min_start_date)
151:

Line 148: NVL(fii_time_api.ent_sd_pqtr_end(l_this_date),l_min_start_date),

144: l_this_date_gov := FII_TIME_API.ent_cper_end(l_this_date);
145: */
146:
147: SELECT NVL(fii_time_api.ent_sd_pper_end(l_this_date),l_min_start_date),
148: NVL(fii_time_api.ent_sd_pqtr_end(l_this_date),l_min_start_date),
149: NVL(fii_time_api.ent_sd_lyr_end(l_this_date),l_min_start_date),
150: NVL( fii_time_api.ent_cper_end(l_this_date),l_min_start_date)
151:
152: INTO l_pp_this_date,

Line 149: NVL(fii_time_api.ent_sd_lyr_end(l_this_date),l_min_start_date),

145: */
146:
147: SELECT NVL(fii_time_api.ent_sd_pper_end(l_this_date),l_min_start_date),
148: NVL(fii_time_api.ent_sd_pqtr_end(l_this_date),l_min_start_date),
149: NVL(fii_time_api.ent_sd_lyr_end(l_this_date),l_min_start_date),
150: NVL( fii_time_api.ent_cper_end(l_this_date),l_min_start_date)
151:
152: INTO l_pp_this_date,
153: l_pq_this_date,

Line 150: NVL( fii_time_api.ent_cper_end(l_this_date),l_min_start_date)

146:
147: SELECT NVL(fii_time_api.ent_sd_pper_end(l_this_date),l_min_start_date),
148: NVL(fii_time_api.ent_sd_pqtr_end(l_this_date),l_min_start_date),
149: NVL(fii_time_api.ent_sd_lyr_end(l_this_date),l_min_start_date),
150: NVL( fii_time_api.ent_cper_end(l_this_date),l_min_start_date)
151:
152: INTO l_pp_this_date,
153: l_pq_this_date,
154: l_ly_this_date,