APPS.FEM_LEDGERS_UTIL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 143

  SELECT dimension_id
  INTO v_ledger_dim_id
  FROM fem_dimensions_b
  WHERE dimension_varchar_label = 'LEDGER';

Line: 149

  SELECT attribute_id
  INTO v_calp_hier_attr_id
  FROM fem_dim_attributes_b
  WHERE dimension_id= v_ledger_dim_id
  AND attribute_varchar_label = 'CAL_PERIOD_HIER_OBJ_DEF_ID';

Line: 156

  SELECT version_id
  INTO v_calp_hier_vrs_id
  FROM fem_dim_attr_versions_b
  WHERE attribute_id = v_calp_hier_attr_id
  AND default_version_flag = 'Y';

Line: 163

  SELECT dim_attribute_numeric_member
  INTO v_calp_hier_obj_def_id
  FROM fem_ledgers_attr
  WHERE ledger_id = p_ledger_id
  AND attribute_id = v_calp_hier_attr_id
  AND version_id = v_calp_hier_vrs_id;

Line: 171

  SELECT H.calendar_id
  INTO x_calendar_id
  FROM fem_hierarchies H, fem_hier_definitions D, fem_object_definition_b O
  WHERE D.hierarchy_obj_def_id = v_calp_hier_obj_def_id
  AND D.hierarchy_obj_def_id = O.object_definition_id
  AND O.object_id = H.hierarchy_obj_id;