eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_TD_UTIL dependencies on PAY_ELEMENT_TYPES_F

Line 585: FROM hxt_pay_element_types_f_ddf_v petv

581: IS
582: CURSOR fixed_amount_cur (c_element_type_id NUMBER)
583: IS
584: SELECT petv.hxt_premium_amount
585: FROM hxt_pay_element_types_f_ddf_v petv
586: WHERE petv.hxt_earning_category = 'OTH'
587: AND petv.hxt_premium_type = 'FIXED'
588: AND petv.element_type_id = c_element_type_id
589: AND petv.effective_start_date <= p_effective_start_date

Line 890: hxt_pay_element_types_f_ddf_v eltv,

886: IS
887: SELECT hrw.time_in, hrw.time_out, hrw.hours, hrw.element_type_id,
888: hrw.date_worked, eltv.hxt_earning_category
889: FROM hxt_det_hours_worked hrw,
890: hxt_pay_element_types_f_ddf_v eltv,
891: pay_element_types_f elt
892: WHERE elt.element_type_id = hrw.element_type_id
893: AND eltv.hxt_earning_category IN ('REG', 'OVT', 'ABS')
894: AND hrw.date_worked BETWEEN elt.effective_start_date

Line 891: pay_element_types_f elt

887: SELECT hrw.time_in, hrw.time_out, hrw.hours, hrw.element_type_id,
888: hrw.date_worked, eltv.hxt_earning_category
889: FROM hxt_det_hours_worked hrw,
890: hxt_pay_element_types_f_ddf_v eltv,
891: pay_element_types_f elt
892: WHERE elt.element_type_id = hrw.element_type_id
893: AND eltv.hxt_earning_category IN ('REG', 'OVT', 'ABS')
894: AND hrw.date_worked BETWEEN elt.effective_start_date
895: AND elt.effective_end_date