SELECT PERIOD_NAME, PERIOD_SET_NAME, START_DATE, END_DATE, PERIOD_TYPE, USER_PERIOD_TYPE, PERIOD_YEAR, PERIOD_NUM, QUARTER_NUM, ENTERED_PERIOD_NAME, ADJUSTMENT_PERIOD_FLAG, NUMBER_PER_FISCAL_YEAR, DESCRIPTION FROM GL_PERIODS_V WHERE PERIOD_SET_NAME = FND_PROFILE.Value('AMW_CALENDAR')
SELECT PERIOD_NAME
, PERIOD_SET_NAME
, START_DATE
, END_DATE
, PERIOD_TYPE
, USER_PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, ENTERED_PERIOD_NAME
, ADJUSTMENT_PERIOD_FLAG
, NUMBER_PER_FISCAL_YEAR
, DESCRIPTION
FROM GL_PERIODS_V
WHERE PERIOD_SET_NAME = FND_PROFILE.VALUE('AMW_CALENDAR')
|
|
|