217: , GL_PS.period_year
218: , GL_PS.period_num
219: , GL_PS.quarter_num
220: FROM
221: GL_PERIOD_STATUSES GL_PS
222: , GL_PERIOD_STATUSES PO_PS
223: , GL_SETS_OF_BOOKS SOB
224: WHERE SOB.set_of_books_id = l_set_of_books_id
225: AND GL_PS.application_id = 101
218: , GL_PS.period_num
219: , GL_PS.quarter_num
220: FROM
221: GL_PERIOD_STATUSES GL_PS
222: , GL_PERIOD_STATUSES PO_PS
223: , GL_SETS_OF_BOOKS SOB
224: WHERE SOB.set_of_books_id = l_set_of_books_id
225: AND GL_PS.application_id = 101
226: AND PO_PS.application_id = 201