APPS.HXT_TC_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

  select sum(thw.hours)
  from hxt_sum_hours_worked  thw
   where thw.tim_id = p_tim_id
     and thw.element_type_id is null;

Line: 13

  select sum(thw.hours)
    from hxt_sum_hours_worked thw
        ,pay_element_types_f elt
        ,hxt_pay_element_types_f_ddf_v eltv
   where thw.tim_id = p_tim_id
     and thw.element_type_id is not null
     and thw.element_type_id = elt.element_type_id
     and elt.element_type_id = eltv.element_type_id
     and thw.date_worked between eltv.effective_start_date
                             and eltv.effective_end_date
     and eltv.hxt_earning_category in ('ABS','REG','OVT');

Line: 59

PROCEDURE update_approver(p_tim_row_id IN VARCHAR2,
p_approv_person_id   NUMBER,
p_approved_timestamp DATE,
p_last_updated_by    NUMBER,
p_last_update_date   DATE,
p_last_update_login  NUMBER
) is

begin

update HXT_TIMECARDS_F
set
approv_person_id = p_approv_person_id,
approved_timestamp = p_approved_timestamp,
last_updated_by = p_last_updated_by,
last_update_date = p_last_update_date,
last_update_login = p_last_update_login
where rowid = p_tim_row_id;

Line: 78

end   update_approver;