[Home] [Help]
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
Name |
CONSOLIDATION_SET_ID |
PERIOD_NAME |
PAYROLL_ID |
TIME_PERIOD_ID |
START_DATE |
END_DATE |