APPS.GCS_DP_DYNAMIC_PKG dependencies on GCS_HIERARCHIES_B

Line 1275: FROM gcs_hierarchies_b

1271: ' SELECT threshold_amount,
1272: threshold_currency
1273: INTO l_threshold,
1274: l_threshold_currency
1275: FROM gcs_hierarchies_b
1276: WHERE hierarchy_id = '||p_hierarchy_id);
1277: END IF;
1278: SELECT threshold_amount, threshold_currency
1279: INTO l_threshold, l_threshold_currency

Line 1280: FROM gcs_hierarchies_b

1276: WHERE hierarchy_id = '||p_hierarchy_id);
1277: END IF;
1278: SELECT threshold_amount, threshold_currency
1279: INTO l_threshold, l_threshold_currency
1280: FROM gcs_hierarchies_b
1281: WHERE hierarchy_id = p_hierarchy_id;
1282: BEGIN
1283: gcs_templates_pkg.get_dimension_template
1284: (p_hierarchy_id => p_hierarchy_id,

Line 1894: FROM gcs_hierarchies_b

1890: fnd_log.STRING (fnd_log.level_statement,
1891: g_pkg_name || '.' || l_api_name,
1892: ' SELECT threshold_amount, threshold_currency
1893: INTO l_threshold, l_threshold_currency
1894: FROM gcs_hierarchies_b
1895: WHERE hierarchy_id = '||p_hierarchy_id);
1896: END IF;
1897: SELECT threshold_amount, threshold_currency
1898: INTO l_threshold, l_threshold_currency

Line 1899: FROM gcs_hierarchies_b

1895: WHERE hierarchy_id = '||p_hierarchy_id);
1896: END IF;
1897: SELECT threshold_amount, threshold_currency
1898: INTO l_threshold, l_threshold_currency
1899: FROM gcs_hierarchies_b
1900: WHERE hierarchy_id = p_hierarchy_id;
1901: BEGIN
1902: gcs_templates_pkg.get_dimension_template
1903: (p_hierarchy_id => p_hierarchy_id,