View: PAY_JP_EFFECTIVE_MONTHS_V

Product:	PAY - Payroll
Description:	This view is used in a lookup called from SRS definition "Geppen". This view is used for Japanese localization only.
Implementation/DBA Data:	APPS.PAY_JP_EFFECTIVE_MONTHS_V

View Text

SELECT FND.EFFECTIVE_DATE
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 1)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 2)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 3)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 4)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 5)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 6)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -1)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -2)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -3)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -4)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -5)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -6)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID')

Columns