eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
View: PAY_PAYWSPGL_PAYROLLS
Product: PAY - Payroll
Description: PAY_PAYWSPGL_PAYROLLS is a view based on the view PAY_PAYROLLS_F. It lists all of the payrolls visible within the current security profile as of the effective date. It is designed specifically to be used in form PAYWSPGL.
Implementation/DBA Data:
APPS.PAY_PAYWSPGL_PAYROLLS
View Text
SELECT PAYROLL_NAME , PERIOD_TYPE , PAYROLL_ID , EFFECTIVE_START_DATE , EFFECTIVE_END_DATE , BUSINESS_GROUP_ID , GL_SET_OF_BOOKS_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , CREATED_BY , CREATION_DATE FROM PAY_PAYROLLS_F PP WHERE PP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('SESSIONID')) AND PP.EFFECTIVE_END_DATE >= (SELECT SE.EFFECTIVE_DATE FROM FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('SESSIONID'))
Columns
Name
PAYROLL_NAME
PERIOD_TYPE
PAYROLL_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
GL_SET_OF_BOOKS_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE