DBA Data[Home] [Help]

APPS.OZF_AR_PAYMENT_PVT dependencies on GL_PERIOD_STATUSES

Line 1601: FROM gl_period_statuses gl

1597: CURSOR csr_gl_date_open( p_set_of_books_id IN NUMBER
1598: , p_gl_date IN DATE
1599: ) IS
1600: SELECT DECODE(MAX(gl.period_name), '', 0, 1)
1601: FROM gl_period_statuses gl
1602: WHERE gl.application_id = 222
1603: AND gl.set_of_books_id = p_set_of_books_id
1604: AND gl.adjustment_period_flag = 'N'
1605: AND p_gl_date BETWEEN gl.start_date AND gl.end_date