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
