DBA Data[Home] [Help]

APPS.FEM_DIM_PRS_UTILS_PVT dependencies on FEM_DIMENSIONS_B

Line 17: from fem_dimensions_b dim

13: ,xdim.member_tl_table_name
14: ,xdim.attribute_table_name
15: ,xdim.member_col
16: ,xdim.personal_hierarchy_table_name
17: from fem_dimensions_b dim
18: ,fem_xdim_dimensions xdim
19: where xdim.dimension_id = dim.dimension_id
20: and xdim.hier_editor_managed_flag = 'Y'
21: and xdim.read_only_flag = 'N'

Line 279: l_dimension_varchar_label FEM_DIMENSIONS_B.dimension_varchar_label%TYPE;

275: p_user_id IN number
276: )
277: IS
278: l_api_name CONSTANT VARCHAR2(30) := 'Purge_Personal_Members_Pvt';
279: l_dimension_varchar_label FEM_DIMENSIONS_B.dimension_varchar_label%TYPE;
280: l_sql_stmt VARCHAR2(2000) := NULL;
281: BEGIN
282:
283: l_dimension_varchar_label := p_xdim_rec.dimension_varchar_label;