168: --
169: FUNCTION Get_Reporting_Level_Name
170: RETURN VARCHAR2
171: IS
172: l_reporting_level_name fnd_lookups.meaning%TYPE;
173:
174: BEGIN
175: SELECT meaning
176: INTO l_reporting_level_name
173:
174: BEGIN
175: SELECT meaning
176: INTO l_reporting_level_name
177: FROM fnd_lookups
178: WHERE lookup_type = 'XLA_MO_REPORTING_LEVEL'
179: AND lookup_code = g_reporting_level;
180:
181: RETURN l_reporting_level_name;
241: , x_top_reporting_level IN VARCHAR2
242: )
243: IS
244: SELECT 1
245: FROM fnd_lookups lp
246: WHERE lookup_type = 'XLA_MO_REPORTING_LEVEL'
247: AND lookup_code = x_reporting_level
248: AND TO_NUMBER(lookup_code) >=
249: TO_NUMBER(x_top_reporting_level);