Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSP_REPORT_PERIOD_FREQUENCY_V |
SELECT PRB.ROWID ROW_ID
, PRB.PERIOD_FREQUENCY_ID
, PRT.PERIOD_FREQUENCY
, PRB.OBJECT_VERSION_NUMBER
, PRB.START_DATE
, PRB.UNIT_OF_MEASURE
, PRB.PERIOD_DURATION
, PRB.REPORT_TYPE
, PRB.LAST_UPDATE_DATE
, PRB.LAST_UPDATED_BY
, PRB.LAST_UPDATE_LOGIN
, PRB.CREATED_BY
, PRB.CREATION_DATE
FROM PSP_REPORT_PERIOD_FREQUENCY_B PRB
, PSP_REPORT_PERIOD_FREQUENCY_TL PRT
WHERE PRB.PERIOD_FREQUENCY_ID = PRT.PERIOD_FREQUENCY_ID
AND PRT.LANGUAGE = USERENV('LANG')