DBA Data[Home] [Help]

APPS.GCS_PERIOD_INIT_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 226: fem_cal_periods_attr lp_year,

222: CURSOR last_period_c IS
223: SELECT lp.cal_period_id
224: FROM fem_cal_periods_b lp,
225: fem_cal_periods_b fp,
226: fem_cal_periods_attr lp_year,
227: fem_cal_periods_attr fp_year,
228: fem_cal_periods_attr lp_num
229: WHERE fp.cal_period_id = p_next_cal_period_id
230: AND lp.dimension_group_id = fp.dimension_group_id

Line 227: fem_cal_periods_attr fp_year,

223: SELECT lp.cal_period_id
224: FROM fem_cal_periods_b lp,
225: fem_cal_periods_b fp,
226: fem_cal_periods_attr lp_year,
227: fem_cal_periods_attr fp_year,
228: fem_cal_periods_attr lp_num
229: WHERE fp.cal_period_id = p_next_cal_period_id
230: AND lp.dimension_group_id = fp.dimension_group_id
231: AND lp.calendar_id = fp.calendar_id

Line 228: fem_cal_periods_attr lp_num

224: FROM fem_cal_periods_b lp,
225: fem_cal_periods_b fp,
226: fem_cal_periods_attr lp_year,
227: fem_cal_periods_attr fp_year,
228: fem_cal_periods_attr lp_num
229: WHERE fp.cal_period_id = p_next_cal_period_id
230: AND lp.dimension_group_id = fp.dimension_group_id
231: AND lp.calendar_id = fp.calendar_id
232: AND lp_year.cal_period_id = lp.cal_period_id