DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on GL_PERIOD_STATUSES

Line 4484: FROM GL_PERIOD_STATUSES GLPS

4480: AND ASI.PAYMENT_NUM = ASI2.PAYMENT_NUM
4481: AND ASI2.CHECKRUN_ID = l_checkrun_id
4482: AND NOT EXISTS
4483: (SELECT NULL
4484: FROM GL_PERIOD_STATUSES GLPS
4485: WHERE TRUNC(l_check_date) BETWEEN GLPS.START_DATE AND GLPS.END_DATE
4486: AND GLPS.CLOSING_STATUS = 'O' --For Payment Only Open Periods are allowed
4487: AND GLPS.APPLICATION_ID = 200
4488: AND GLPS.SET_OF_BOOKS_ID = ASI2.SET_OF_BOOKS_ID));