APPS.GCS_DATA_PREP_PKG dependencies on GCS_HIERARCHIES_B

Line 459: FROM gcs_hierarchies_b ghb

455: fnd_log.STRING(fnd_log.level_statement,
456: g_pkg_name || '.' || l_api_name,
457: 'SELECT ghb.calendar_id, ghb.dimension_group_id
458: INTO l_calendar_id, l_dimension_grp_id
459: FROM gcs_hierarchies_b ghb
460: WHERE ghb.hierarchy_id = ' ||
461: p_hierarchy_id);
462: END IF;
463: SELECT ghb.calendar_id, ghb.dimension_group_id

Line 465: FROM gcs_hierarchies_b ghb

461: p_hierarchy_id);
462: END IF;
463: SELECT ghb.calendar_id, ghb.dimension_group_id
464: INTO l_calendar_id, l_dimension_grp_id
465: FROM gcs_hierarchies_b ghb
466: WHERE ghb.hierarchy_id = p_hierarchy_id;
467: -- retrieve the cal_period_map_id according to source data
468: -- (l_source_calendar_id, l_target_cal_period_id)
469: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement THEN

Line 2486: FROM gcs_hierarchies_b

2482: '' SELECT threshold_amount,
2483: threshold_currency
2484: INTO l_threshold,
2485: l_threshold_currency
2486: FROM gcs_hierarchies_b
2487: WHERE hierarchy_id = ''||p_hierarchy_id);
2488: END IF;
2489: SELECT threshold_amount, threshold_currency
2490: INTO l_threshold, l_threshold_currency

Line 2491: FROM gcs_hierarchies_b

2487: WHERE hierarchy_id = ''||p_hierarchy_id);
2488: END IF;
2489: SELECT threshold_amount, threshold_currency
2490: INTO l_threshold, l_threshold_currency
2491: FROM gcs_hierarchies_b
2492: WHERE hierarchy_id = p_hierarchy_id;
2493: BEGIN
2494: gcs_templates_pkg.get_dimension_template
2495: (p_hierarchy_id => p_hierarchy_id,

Line 3063: FROM gcs_hierarchies_b

3059: fnd_log.STRING (fnd_log.level_statement,
3060: g_pkg_name || ''.'' || l_api_name,
3061: '' SELECT threshold_amount, threshold_currency
3062: INTO l_threshold, l_threshold_currency
3063: FROM gcs_hierarchies_b
3064: WHERE hierarchy_id = ''||p_hierarchy_id);
3065: END IF;
3066: SELECT threshold_amount, threshold_currency
3067: INTO l_threshold, l_threshold_currency

Line 3068: FROM gcs_hierarchies_b

3064: WHERE hierarchy_id = ''||p_hierarchy_id);
3065: END IF;
3066: SELECT threshold_amount, threshold_currency
3067: INTO l_threshold, l_threshold_currency
3068: FROM gcs_hierarchies_b
3069: WHERE hierarchy_id = p_hierarchy_id;
3070: BEGIN
3071: gcs_templates_pkg.get_dimension_template
3072: (p_hierarchy_id => p_hierarchy_id,