DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on GL_PERIOD_STATUSES

Line 2117: FROM gl_period_statuses

2113: SELECT period_name,
2114: start_date,
2115: end_date,
2116: closing_status
2117: FROM gl_period_statuses
2118: WHERE application_id = jai_constants.gl_application_id
2119: AND set_of_books_id = cp_sob_id
2120: AND closing_status IN('O', 'F')
2121: AND cp_accounting_date BETWEEN start_date

Line 2597: FROM gl_period_statuses

2593: (SELECT period_name,
2594: start_date,
2595: end_date,
2596: closing_status
2597: FROM gl_period_statuses
2598: WHERE application_id = jai_constants.gl_application_id
2599: AND set_of_books_id = lt_sob_id_tab(ln_row_count)
2600: AND start_date > lt_gl_date(ln_row_count)
2601: AND adjustment_period_flag = 'N' -- mmurtuza for bug 16181417