1099: fem_cal_periods_b fcpb_target,
1100: gcs_cal_period_maps gcpm,
1101: fem_cal_periods_attr fcpb_source_num,
1102: fem_cal_periods_attr fcpb_source_year,
1103: gcs_cal_period_map_dtls gcpmd
1104: WHERE fcpb_target.cal_period_id = p_cal_period_id
1105: AND fcpb_target.calendar_id = gcpm.target_calendar_id
1106: AND fcpb_target.dimension_group_id = gcpm.target_dimension_group_id
1107: AND gcpm.cal_period_map_id = gcpmd.cal_period_map_id
1131: fem_cal_periods_b fcpb_target,
1132: gcs_cal_period_maps gcpm,
1133: fem_cal_periods_attr fcpb_source_num,
1134: fem_cal_periods_attr fcpb_source_year,
1135: gcs_cal_period_map_dtls gcpmd
1136: WHERE fcpb_target.cal_period_id >= p_cal_period_id
1137: AND fcpb_target.calendar_id = gcpm.target_calendar_id
1138: AND fcpb_target.dimension_group_id = gcpm.target_dimension_group_id
1139: AND gcpm.cal_period_map_id = gcpmd.cal_period_map_id
1172: fem_cal_periods_b fcpb_target,
1173: gcs_cal_period_maps gcpm,
1174: fem_cal_periods_attr fcpb_target_num,
1175: fem_cal_periods_attr fcpb_target_year,
1176: gcs_cal_period_map_dtls gcpmd
1177: WHERE fcpb_source.cal_period_id = p_cal_period_id
1178: AND fcpb_source.calendar_id = gcpm.source_calendar_id
1179: AND fcpb_source.dimension_group_id = gcpm.source_dimension_group_id
1180: AND gcpm.cal_period_map_id = gcpmd.cal_period_map_id