DBA Data[Home] [Help]

VIEW: APPS.HRI_CS_TIME_HR_CLNDRS_V

Source

View Text - Preformatted

SELECT ptp.start_date period_start_date ,ptp.end_date period_end_date ,ptp.payroll_id payroll_id ,ptp.time_period_id time_period_id ,ptp.period_name period_name ,ptp.period_num period_number ,ptp.period_type period_type FROM per_time_periods ptp WITH READ ONLY
View Text - HTML Formatted

SELECT PTP.START_DATE PERIOD_START_DATE
, PTP.END_DATE PERIOD_END_DATE
, PTP.PAYROLL_ID PAYROLL_ID
, PTP.TIME_PERIOD_ID TIME_PERIOD_ID
, PTP.PERIOD_NAME PERIOD_NAME
, PTP.PERIOD_NUM PERIOD_NUMBER
, PTP.PERIOD_TYPE PERIOD_TYPE
FROM PER_TIME_PERIODS PTP WITH READ ONLY