DBA Data[Home] [Help]

APPS.OZF_AR_PAYMENT_PVT dependencies on GL_PERIOD_STATUSES

Line 1315: FROM gl_period_statuses gl

1311: CURSOR csr_gl_date_open( p_set_of_books_id IN NUMBER
1312: , p_gl_date IN DATE
1313: ) IS
1314: SELECT DECODE(MAX(gl.period_name), '', 0, 1)
1315: FROM gl_period_statuses gl
1316: WHERE gl.application_id = 222
1317: AND gl.set_of_books_id = p_set_of_books_id
1318: AND gl.adjustment_period_flag = 'N'
1319: AND p_gl_date BETWEEN gl.start_date AND gl.end_date