831: INTO l_period_status
832: FROM gl_period_statuses gps,
833: gl_periods gp,
834: gl_sets_of_books gb,
835: gl_period_types gpt,
836: fnd_application fa
837: WHERE
838: gb.set_of_books_id = p_sob_id1 AND
839: gp.period_set_name = gb.period_set_name AND