173: , p_period_type IN VARCHAR2
174: , p_default_date IN DATE
175: ) IS
176: SELECT glpr.period_name period_name 177: FROM gl_periods glpr 178: WHERE p_period_set_name = glpr.period_set_name
179: AND p_period_type = glpr.period_type
180: AND glpr.adjustment_period_flag = 'N'
181: AND p_default_date BETWEEN TRUNC(glpr.start_date)