APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_DIM_ATTRIBUTES_TL

Line 1123: v_cal_attr_name FEM_DIM_ATTRIBUTES_TL.attribute_name%TYPE;

1119: v_dim_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
1120: v_dim_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
1121: v_cal_attr_id FEM_DIM_ATTRIBUTES_B.attribute_id%TYPE;
1122: v_cal_attr_ver_id FEM_DIM_ATTR_VERSIONS_B.version_id%TYPE;
1123: v_cal_attr_name FEM_DIM_ATTRIBUTES_TL.attribute_name%TYPE;
1124: v_incl_adj_period FEM_CALENDARS_ATTR.dim_attribute_varchar_member%TYPE;
1125:
1126: v_return_code NUMBER;
1127: v_sql VARCHAR2(1000);

Line 9002: FROM fem_dim_attributes_tl

8998: BEGIN
8999:
9000: SELECT attribute_name
9001: INTO v_attr_name
9002: FROM fem_dim_attributes_tl
9003: WHERE attribute_id = p_attr_id
9004: AND language = userenv('LANG');
9005:
9006: RETURN v_attr_name;

Line 9026: fem_dim_attributes_tl T

9022:
9023: SELECT T.attribute_name
9024: INTO v_attr_name
9025: FROM fem_dim_attributes_b B,
9026: fem_dim_attributes_tl T
9027: WHERE B.attribute_varchar_label = p_attr_label
9028: AND B.dimension_id = p_dim_id
9029: AND T.attribute_id = B.attribute_id
9030: AND T.language = userenv('LANG');

Line 9052: fem_dim_attributes_tl AT,

9048:
9049: SELECT AT.attribute_name
9050: INTO v_attr_name
9051: FROM fem_dim_attributes_b AB,
9052: fem_dim_attributes_tl AT,
9053: fem_dimensions_b DB
9054: WHERE AB.attribute_varchar_label = p_attr_label
9055: AND DB.dimension_varchar_label = p_dim_label
9056: AND AB.dimension_id = DB.dimension_id