151: BEGIN
152:
153: SELECT period_name
154: INTO l_period_name 155: FROM gl_period_statuses 156: WHERE application_id = 222
157: AND set_of_books_id = arp_standard.sysparm.set_of_books_id
158: AND p_gl_date >= start_date
159: AND p_gl_date <= end_date