DBA Data[Home] [Help]

APPS.MSD_CS_DFN_UTL dependencies on MSD_LEVELS

Line 130: from msd_levels

126: Function get_level_id ( p_dim_code in varchar2, p_level_name in varchar2) return number is
127:
128: cursor c_lvl is
129: select level_id
130: from msd_levels
131: where dimension_code = p_dim_code and level_name = p_level_name;
132:
133: l_ret number;
134:

Line 156: from msd_levels

152: Function get_level_name ( p_dim_code in varchar2, p_level_id varchar2) return varchar2 is
153:
154: cursor c_lvl is
155: select level_name
156: from msd_levels
157: where dimension_code = p_dim_code and level_id = p_level_id;
158:
159: l_ret varchar2(80);
160:

Line 188: from msd_levels_v

184: lookup_code = p_level_id;
185:
186: cursor c_lvl is
187: select description
188: from msd_levels_v
189: where owning_dimension_code = p_dim_code and level_id = p_level_id;
190:
191: l_ret varchar2(80);
192: