APPS.FEM_MIR_PKG dependencies on FEM_XDIM_DIMENSIONS_VL

Line 1513: FROM fem_xdim_dimensions_vl XDIM

1509: FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)
1510: ,NULL)
1511: )
1512: INTO l_member_display_code
1513: FROM fem_xdim_dimensions_vl XDIM
1514: WHERE XDIM.dimension_id = p_dimension_id;
1515:
1516: FEM_ENGINES_PKG.Tech_Message (
1517: p_severity => c_log_level_2

Line 1618: FROM fem_xdim_dimensions_vl XDIM

1614: ,FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)
1615: ,NULL)
1616: )
1617: INTO l_member_display_code
1618: FROM fem_xdim_dimensions_vl XDIM
1619: WHERE XDIM.dimension_varchar_label = p_dimension_varchar_label;
1620:
1621: FEM_ENGINES_PKG.Tech_Message (
1622: p_severity => c_log_level_2

Line 1739: FROM fem_xdim_dimensions_vl XDIM

1735: ,FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)
1736: ,NULL
1737: )
1738: INTO l_value_set_id
1739: FROM fem_xdim_dimensions_vl XDIM
1740: WHERE XDIM.dimension_varchar_label = p_dimension_varchar_label;
1741:
1742: FEM_ENGINES_PKG.Tech_Message (
1743: p_severity => c_log_level_1

Line 1899: FROM fem_xdim_dimensions_vl

1895: -------------------------------------
1896: BEGIN
1897: SELECT dimension_varchar_label
1898: INTO l_dimension_varchar_label
1899: FROM fem_xdim_dimensions_vl
1900: WHERE dimension_id = p_dimension_id;
1901:
1902: EXCEPTION
1903:

Line 1919: FROM fem_xdim_dimensions_vl XDIM

1915: ,FEM_DIMENSION_UTIL_PKG.Dimension_Value_Set_Id(XDIM.dimension_id)
1916: ,NULL
1917: )
1918: INTO l_value_set_id
1919: FROM fem_xdim_dimensions_vl XDIM
1920: WHERE XDIM.dimension_id = p_dimension_id;
1921:
1922: EXCEPTION
1923: WHEN NO_DATA_FOUND THEN

Line 2321: ,fem_xdim_dimensions_vl XDIM

2317: INTO l_gl_period_num
2318: FROM fem_cal_periods_attr calp_attr
2319: ,fem_dim_attributes_b ATTR
2320: ,fem_dim_attr_versions_b VER
2321: ,fem_xdim_dimensions_vl XDIM
2322: WHERE XDIM.dimension_varchar_label = 'CAL_PERIOD'
2323: AND ATTR.dimension_id = XDIM.dimension_id
2324: AND ATTR.attribute_varchar_label = 'GL_PERIOD_NUM'
2325: AND VER.attribute_id = ATTR.attribute_id

Line 2417: ,fem_xdim_dimensions_vl XDIM

2413: INTO l_cal_period_end_date
2414: FROM fem_cal_periods_attr calp_attr
2415: ,fem_dim_attributes_b ATTR
2416: ,fem_dim_attr_versions_b VER
2417: ,fem_xdim_dimensions_vl XDIM
2418: WHERE XDIM.dimension_varchar_label = 'CAL_PERIOD'
2419: AND ATTR.dimension_id = XDIM.dimension_id
2420: AND ATTR.attribute_varchar_label = 'CAL_PERIOD_END_DATE'
2421: AND VER.attribute_id = ATTR.attribute_id