APPS.AP_AUTOSELECT_PKG dependencies on GL_PERIOD_STATUSES

Line 3438: FROM GL_PERIOD_STATUSES GLPS

3434: AND ASI.PAYMENT_NUM = ASI2.PAYMENT_NUM
3435: AND ASI2.CHECKRUN_ID = l_checkrun_id
3436: AND NOT EXISTS
3437: (SELECT NULL
3438: FROM GL_PERIOD_STATUSES GLPS
3439: WHERE TRUNC(l_check_date) BETWEEN GLPS.START_DATE AND GLPS.END_DATE
3440: AND GLPS.CLOSING_STATUS IN ('O', 'F')
3441: AND GLPS.APPLICATION_ID = 200
3442: AND GLPS.SET_OF_BOOKS_ID = ASI2.SET_OF_BOOKS_ID));