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: PSP_TIME_PERIODS_V

Product:	PSP - Labor Distribution
Description:	Used for PSP_SRS_PERIOD_NAME value set definition
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.PERIOD_NAME
, B.PAYROLL_NAME
, A.PERIOD_TYPE
, A.TIME_PERIOD_ID
, B.BUSINESS_GROUP_ID
, B.GL_SET_OF_BOOKS_ID
FROM PER_TIME_PERIODS A
, PAY_PAYROLLS_F B
WHERE A.PAYROLL_ID = B.PAYROLL_ID
AND A.END_DATE BETWEEN B.EFFECTIVE_START_DATE
AND B.EFFECTIVE_END_DATE

Columns

Name
PERIOD_NAME
PAYROLL_NAME
PERIOD_TYPE
TIME_PERIOD_ID
BUSINESS_GROUP_ID
SET_OF_BOOKS_ID