SELECT employee_number ,pay_element,pay_element_type  ,total_hours_worked ,total_cost ,rate 
   , TOTAL_HOURS_WORKED*RATE
FROM xxaai_ext.xxaai_adp_emp_weekly_cost
WHERE time_period_id = 4014

delete from  xxaai_ext.xxaai_adp_emp_weekly_cost
WHERE time_period_id = 4014


SELECT hdhwf.hours , hdhwf.date_worked, hdhwf.assignment_id,hdhwf.element_type_id
        ,petf.element_name
        ,ppa.project_id, ppa.segment1
        ,pt.task_id, pt.task_number, ppa.org_id
    FROM hxt_det_hours_worked_f hdhwf
        ,hxt_timecards_f htf
        ,pa_projects_all ppa
        ,pa_tasks pt
        ,pay_element_types_f petf
   WHERE time_period_id = 4014
     AND htf.for_person_id = 3311
     AND hdhwf.tim_id = htf.id
     AND ppa.project_id = pt.project_id
     AND ppa.project_id = hdhwf.project_id
     AND pt.task_id = hdhwf.tas_id
     AND petf.element_type_id = hdhwf.element_type_id
	 AND UPPER(petf.element_name) NOT IN ('EXTRA EFFORT','EXTRA EFFORT INDIRECT')
	 
     
     Overtime Union Lead Temp
     Union Lead Temporary Overtime
     
     SELECT hav.alias_value_name ,pet.expenditure_type, hav.attribute3
	  FROM  pa_expenditure_types pet, hxc_alias_values_v hav, pay_element_types_f petf
	 WHERE pet.expenditure_type = hav.attribute2
	   AND petf.element_type_id = hav.attribute1
	--  AND hav.enabled_flag = 'Y'
	   AND petf.element_name = 'Overtime Union Lead Temp'
	   AND SYSDATE BETWEEN pet.start_date_active AND NVL(pet.end_date_active,SYSDATE+1000)
 	   AND SYSDATE BETWEEN petf.effective_start_date AND NVL(petf.effective_end_date,SYSDATE+1000)
 	   AND SYSDATE BETWEEN hav.date_from AND NVL(DATE_TO,SYSDATE+1000);