[Home] [Help]
1595: AND aid.invoice_id = ai.invoice_id
1596: AND aid.org_id = fsp.org_id
1597: AND EXISTS
1598: (SELECT 1
1599: FROM gl_period_statuses glps
1600: WHERE glps.application_id = 200
1601: AND glps.set_of_books_id = ai.set_of_books_id
1602: AND nvl(glps.adjustment_period_flag, 'N') = 'N'
1603: AND ai.gl_date BETWEEN glps.start_date