DBA Data[Home] [Help]

APPS.AR_CREATE_ACCTING_SRS dependencies on GL_PERIOD_STATUSES

Line 203: FROM gl_period_statuses glp

199:
200: CURSOR c_valid_date(p_ledger_id IN VARCHAR2,
201: p_date IN DATE) IS
202: SELECT 'Y'
203: FROM gl_period_statuses glp
204: WHERE glp.application_id = 222
205: AND p_date BETWEEN glp.start_date AND glp.end_date
206: AND glp.set_of_books_id = p_ledger
207: AND glp.closing_status IN ('O','F');