APPS.PO_RELGEN_PKG dependencies on GL_PERIOD_STATUSES

Line 125: FROM GL_PERIOD_STATUSES GPS,

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

Line 2979: from GL_PERIOD_STATUSES PS1, GL_PERIOD_STATUSES PS2,

2975: AND nvl(PLL.cancel_flag,'N') = 'N'
2976: AND nvl(PLL.closed_code,'OPEN') <> 'FINALLY CLOSED'
2977: AND not exists
2978: (SELECT 'find if the GL date is not within Open period'
2979: from GL_PERIOD_STATUSES PS1, GL_PERIOD_STATUSES PS2,
2980: GL_SETS_OF_BOOKS GSOB
2981: WHERE PS1.application_id = 101
2982: AND PS1.set_of_books_id = l_sob_id
2983: AND PS1.closing_status IN ('O','F')