SELECT "CCSP_PAYROLL_DATE_CD"."PAY_BEG_DTM"||' - '|| "CCSP_PAYROLL_DATE_CD"."PAY_END_DTM" as DT_RANGE FROM "CCSP_PAYROLL_DATE_CD" WHERE ("CCSP_PAYROLL_DATE_CD"."DELETE_DTS" is null ) AND ("CCSP_PAYROLL_DATE_CD"."EXP_DTM" is null OR "CCSP_PAYROLL_DATE_CD"."EXP_DTM" >= sysdate) ORDER BY "CCSP_PAYROLL_DATE_CD"."PAY_BEG_DTM" DESC, "CCSP_PAYROLL_DATE_CD"."PAY_END_DTM" DESC;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)