VIEW: APPS.PN_GL_PERIOD_V

Source

View Text - Preformatted

SELECT period_name, start_date, end_date FROM gl_period_statuses g, gl_sets_of_books b WHERE b.set_of_books_id = g.set_of_books_id AND g.application_id = 101 AND g.set_of_books_id = pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID') AND g.period_type = b.accounted_period_type AND g.adjustment_period_flag = 'N' AND closing_status IN ('O', 'F') ORDER BY effective_period_num

View Text - HTML Formatted

SELECT PERIOD_NAME
, START_DATE
, END_DATE
FROM GL_PERIOD_STATUSES G
, GL_SETS_OF_BOOKS B
WHERE B.SET_OF_BOOKS_ID = G.SET_OF_BOOKS_ID
AND G.APPLICATION_ID = 101
AND G.SET_OF_BOOKS_ID = PN_MO_CACHE_UTILS.GET_PROFILE_VALUE('PN_SET_OF_BOOKS_ID')
AND G.PERIOD_TYPE = B.ACCOUNTED_PERIOD_TYPE
AND G.ADJUSTMENT_PERIOD_FLAG = 'N'
AND CLOSING_STATUS IN ('O'
, 'F') ORDER BY EFFECTIVE_PERIOD_NUM