View: PER_ZA_TIME_PERIODS_V4

Product:	PER - Human Resources
Description:	Used for Valid Payroll Period Names for a ConsolidationSet
Implementation/DBA Data:	APPS.PER_ZA_TIME_PERIODS_V4

View Text

SELECT DISTINCT PCS.CONSOLIDATION_SET_ID
, PTP.PERIOD_NAME
, PTP.PAYROLL_ID
, PTP.TIME_PERIOD_ID
, PTP.START_DATE
, PTP.END_DATE
FROM PAY_CONSOLIDATION_SETS PCS
, PAY_PAYROLLS_F PPF
, PER_TIME_PERIODS PTP
WHERE PPF.CONSOLIDATION_SET_ID = PCS.CONSOLIDATION_SET_ID
AND PPF.PAYROLL_ID = PTP.PAYROLL_ID

Columns