DBA Data[Home] [Help]

VIEW: APPS.GL_PERIOD_SETS_V

Source

View Text - Preformatted

SELECT ps.PERIOD_SET_NAME PERIOD_SET_NAME, ps.DESCRIPTION DESCRIPTION, ps.SECURITY_FLAG SECURITY_FLAG, decode(ps.security_flag, 'Y', decode(fnd_data_security.check_function(1.0, 'GL_DAS_CALENDAR_V', 'GL_DAS_CALENDAR',ps.period_set_name, null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') privilege FROM GL_PERIOD_SETS ps
View Text - HTML Formatted

SELECT PS.PERIOD_SET_NAME PERIOD_SET_NAME
, PS.DESCRIPTION DESCRIPTION
, PS.SECURITY_FLAG SECURITY_FLAG
, DECODE(PS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CALENDAR_V'
, 'GL_DAS_CALENDAR'
, PS.PERIOD_SET_NAME
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') PRIVILEGE
FROM GL_PERIOD_SETS PS