196: --
197: FUNCTION Get_Reporting_Entity_Name
198: RETURN VARCHAR2
199: IS
200: l_reporting_entity_name xla_mo_reporting_entities_v
201: .entity_name%TYPE;
202:
203: BEGIN
204:
313: , x_reporting_entity_id IN NUMBER
314: )
315: IS
316: SELECT 1
317: FROM XLA_MO_REPORTING_ENTITIES_V
318: WHERE reporting_level = p_reporting_level
319: /* Commented out NOCOPY the code below, since it does not work for reporting set
320: of books. Intead, making a call to validate_reporting_level to make sure
321: that p_reporting_level value is within the allowed value for profile option