APPS.GCS_DRILLDOWN_UTIL_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 139: fem_cal_periods_attr fcpa_end_date

135:
136: SELECT gea.ledger_id
137: INTO l_ledger_id
138: FROM gcs_entities_attr gea,
139: fem_cal_periods_attr fcpa_end_date
140: WHERE gea.entity_id = p_entity_id
141: AND gea.data_type_code = 'ACTUAL'
142: AND fcpa_end_date.cal_period_id = to_number(p_cal_period_id_str)
143: AND fcpa_end_date.attribute_id = g_cp_enddate_attr_id

Line 229: fem_cal_periods_attr fcpa_end_date

225:
226: SELECT gea.source_system_code
227: INTO l_src_sys_code
228: FROM gcs_entities_attr gea,
229: fem_cal_periods_attr fcpa_end_date
230: WHERE gea.entity_id = p_entity_id
231: AND gea.data_type_code = 'ACTUAL'
232: AND fcpa_end_date.cal_period_id = to_number(p_cal_period_id_str)
233: AND fcpa_end_date.attribute_id = g_cp_enddate_attr_id

Line 330: fem_cal_periods_attr fcpb_source_num,

326: SELECT fcpb_source.cal_period_id source_cal_period_id
327: FROM fem_cal_periods_b fcpb_source,
328: fem_cal_periods_b fcpb_target,
329: gcs_cal_period_maps gcpm,
330: fem_cal_periods_attr fcpb_source_num,
331: fem_cal_periods_attr fcpb_source_year,
332: fem_cal_periods_attr fcpb_target_num,
333: fem_cal_periods_attr fcpb_target_year,
334: gcs_cal_period_map_dtls gcpmd

Line 331: fem_cal_periods_attr fcpb_source_year,

327: FROM fem_cal_periods_b fcpb_source,
328: fem_cal_periods_b fcpb_target,
329: gcs_cal_period_maps gcpm,
330: fem_cal_periods_attr fcpb_source_num,
331: fem_cal_periods_attr fcpb_source_year,
332: fem_cal_periods_attr fcpb_target_num,
333: fem_cal_periods_attr fcpb_target_year,
334: gcs_cal_period_map_dtls gcpmd
335: WHERE fcpb_target.cal_period_id = to_number(p_fch_cal_period_id_str)

Line 332: fem_cal_periods_attr fcpb_target_num,

328: fem_cal_periods_b fcpb_target,
329: gcs_cal_period_maps gcpm,
330: fem_cal_periods_attr fcpb_source_num,
331: fem_cal_periods_attr fcpb_source_year,
332: fem_cal_periods_attr fcpb_target_num,
333: fem_cal_periods_attr fcpb_target_year,
334: gcs_cal_period_map_dtls gcpmd
335: WHERE fcpb_target.cal_period_id = to_number(p_fch_cal_period_id_str)
336: AND fcpb_target.calendar_id = gcpm.target_calendar_id

Line 333: fem_cal_periods_attr fcpb_target_year,

329: gcs_cal_period_maps gcpm,
330: fem_cal_periods_attr fcpb_source_num,
331: fem_cal_periods_attr fcpb_source_year,
332: fem_cal_periods_attr fcpb_target_num,
333: fem_cal_periods_attr fcpb_target_year,
334: gcs_cal_period_map_dtls gcpmd
335: WHERE fcpb_target.cal_period_id = to_number(p_fch_cal_period_id_str)
336: AND fcpb_target.calendar_id = gcpm.target_calendar_id
337: AND fcpb_target.dimension_group_id = gcpm.target_dimension_group_id