APPS.PO_RELGEN_PKG dependencies on GL_PERIOD_STATUSES

Line 126: FROM GL_PERIOD_STATUSES GPS,

122: -- so adding a condition from FSP to check if encumbrance in On.
123:
124: SELECT GPS.PERIOD_NAME
125: INTO x_period_name
126: FROM GL_PERIOD_STATUSES GPS,
127: FINANCIALS_SYSTEM_PARAMETERS FSP
128: WHERE GPS.APPLICATION_ID = 101
129: AND GPS.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
130: AND GPS.ADJUSTMENT_PERIOD_FLAG = 'N'

Line 3033: from GL_PERIOD_STATUSES PS1, GL_PERIOD_STATUSES PS2,

3029: AND nvl(PLL.cancel_flag,'N') = 'N'
3030: AND nvl(PLL.closed_code,'OPEN') <> 'FINALLY CLOSED'
3031: AND not exists
3032: (SELECT 'find if the GL date is not within Open period'
3033: from GL_PERIOD_STATUSES PS1, GL_PERIOD_STATUSES PS2,
3034: GL_SETS_OF_BOOKS GSOB
3035: WHERE PS1.application_id = 101
3036: AND PS1.set_of_books_id = l_sob_id
3037: AND PS1.closing_status IN ('O','F')