DBA Data[Home] [Help]

APPS.GCS_UTILITY_PKG dependencies on GCS_CAL_PERIOD_MAP_DTLS

Line 1103: gcs_cal_period_map_dtls gcpmd

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

Line 1135: gcs_cal_period_map_dtls gcpmd

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

Line 1176: gcs_cal_period_map_dtls gcpmd

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