APPS.GCS_DRILLDOWN_UTIL_PKG dependencies on GCS_DATA_SUB_DTLS

Line 318: FROM gcs_data_sub_dtls gdsd

314:
315: -- Cursor to check whether reverse mapping is needed
316: CURSOR same_calendar_check_c IS
317: SELECT 1
318: FROM gcs_data_sub_dtls gdsd
319: WHERE gdsd.entity_id = p_entity_id
320: AND gdsd.cal_period_id = to_number(p_fch_cal_period_id_str);
321:
322: dummy NUMBER;

Line 362: FROM gcs_data_sub_dtls gdsd

358: 'PRIOR', fcpb_target_year.number_assign_value + 1,
359: 'FOLLOWING', fcpb_target_year.number_assign_value - 1)
360: AND fcpb_source.cal_period_id IN
361: (SELECT gdsd.cal_period_id
362: FROM gcs_data_sub_dtls gdsd
363: WHERE gdsd.entity_id = p_entity_id)
364: ORDER BY fcpb_source_year.number_assign_value desc,
365: fcpb_source_num.number_assign_value desc;
366: