APPS.HXT_USER_EXITS SQL Statements

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

Line: 101

SELECT retro.hours - expired.hours
  FROM hxt_det_hours_worked_f expired,
       hxt_det_hours_worked_f retro
 WHERE retro.rowid = CHARTOROWID(i_row_id)
   AND retro.parent_id = expired.parent_id
   AND retro.element_type_id = expired.element_type_id
   AND expired.pay_status = 'A'
   AND expired.effective_end_date = (SELECT MAX(ex.effective_end_date)
                                       FROM hxt_det_hours_worked_f ex
                                      WHERE ex.effective_end_date < retro.effective_start_date
                                        AND ex.parent_id = retro.parent_id
                                        AND ex.pay_status = 'A'
                                        AND ex.element_type_id = retro.element_type_id);

Line: 136

SELECT retro.amount - expired.amount
  FROM hxt_det_hours_worked_f expired,
       hxt_det_hours_worked_f retro
 WHERE retro.rowid = CHARTOROWID(i_row_id)
   AND retro.parent_id = expired.parent_id
   AND retro.element_type_id = expired.element_type_id
   AND expired.pay_status = 'A'
   AND expired.effective_end_date = (SELECT MAX(ex.effective_end_date)
                                       FROM hxt_det_hours_worked_f ex
                                      WHERE ex.effective_end_date < retro.effective_start_date
                                        AND ex.parent_id = retro.parent_id
                                        AND ex.pay_status = 'A'
                                        AND ex.element_type_id = retro.element_type_id);