APPS.GCS_HIERARCHIES_PKG dependencies on GCS_ENTITY_CONS_ATTRS

Line 1287: FROM gcs_entity_cons_attrs

1283: ORDER BY decode(ctb.default_flag, 'Y', 0, 1), ctb.curr_treatment_id;
1284: BEGIN
1285: SELECT currency_code
1286: INTO to_ccy
1287: FROM gcs_entity_cons_attrs
1288: WHERE hierarchy_id = p_hierarchy_id
1289: AND entity_id = p_parent_id;
1290: SELECT currency_code
1291: INTO from_ccy

Line 1292: FROM gcs_entity_cons_attrs

1288: WHERE hierarchy_id = p_hierarchy_id
1289: AND entity_id = p_parent_id;
1290: SELECT currency_code
1291: INTO from_ccy
1292: FROM gcs_entity_cons_attrs
1293: WHERE hierarchy_id = p_hierarchy_id
1294: AND entity_id = p_child_id;
1295: IF to_ccy = from_ccy THEN
1296: return null;

Line 1637: FROM gcs_entity_cons_attrs

1633: ELSE
1634: -- dominant flag = 'N'
1635: SELECT currency_code
1636: INTO l_from_ccy
1637: FROM gcs_entity_cons_attrs
1638: WHERE hierarchy_id = l_hierarchy_id
1639: AND entity_id = l_child_id;
1640: SELECT currency_code
1641: INTO l_to_ccy

Line 1642: FROM gcs_entity_cons_attrs

1638: WHERE hierarchy_id = l_hierarchy_id
1639: AND entity_id = l_child_id;
1640: SELECT currency_code
1641: INTO l_to_ccy
1642: FROM gcs_entity_cons_attrs
1643: WHERE hierarchy_id = l_hierarchy_id
1644: AND entity_id = l_parent_id;
1645: -- Set the currency treatment that should be used when required
1646: IF l_from_ccy = l_to_ccy THEN