143: INTO l_period_status
144: FROM gl_period_statuses gps,
145: gl_periods gp,
146: gl_sets_of_books gb,
147: gl_period_types gpt,
148: fnd_application fa
149: WHERE
150: gb.set_of_books_id = p_sob_id AND
151: gp.period_set_name = gb.period_set_name AND