-
-

Time Reporting Time Periods

CORE HCM

Time Reporting Time Periods

SELECT HPV.name rep_period_name_grp, HPV.description rep_period_desc_grp, INITCAP(HPV.period_class) period_type_grp, NVL(HR_GENERAL.DECODE_LOOKUP('HWM_ONEORMORE_TYPE', HPV.one_or_many), NVL(HR_GENERAL.DECODE_LOOKUP('HWM_WEEK_TYPE', HPV.week_type), HR_GENERAL.DECODE_LOOKUP('HWM_MONTH_TYPE', HPV.month_type))) period_length_grp, HPV.reference_date sample_st_date_grp, DECODE(TO_CHAR(HPV.period_start_date,'Dy'),'1','Monday','2','Tuesday','3','Wednesday','4','Thursday','5','Friday','6','Saturday','7','Sunday') start_day_grp, HR_GENERAL.DECODE_LOOKUP('YES_NO', HPV.accrual_usage) accrual_usage_grp, HR_GENERAL.DECODE_LOOKUP('YES_NO', HPV.time_entry_usage) time_entry_usage_grp, HR_GENERAL.DECODE_LOOKUP('YES_NO', HPV.approval_usage) approval_usage_grp, HR_GENERAL.DECODE_LOOKUP('YES_NO', HPV.overtime_usage) overtime_usage_grp, HR_GENERAL.DECODE_LOOKUP('YES_NO', HPV.balance_usage) balance_usage_grp FROM HWM_RP_TM_PERIODS_VL HPV WHERE ( (:P_CREATION_TYPE= 'Custom' and HPV.created_by <> 'SEED_DATA_FROM_APPLICATION' ) OR (:P_CREATION_TYPE = 'Seeded' and HPV.created_by = 'SEED_DATA_FROM_APPLICATION' ) OR (:P_CREATION_TYPE = 'Seeded Modified' and HPV.created_by = 'SEED_DATA_FROM_APPLICATION' and HPV.last_updated_by <> 'SEED_DATA_FROM_APPLICATION') OR (:P_CREATION_TYPE = 'ALL') ) ORDER BY HPV.NAME