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 1371: FROM hxt_pay_element_types_f_ddf_v petv

1367: IS
1368: CURSOR fixed_amount_cur (c_element_type_id NUMBER)
1369: IS
1370: SELECT petv.hxt_premium_amount
1371: FROM hxt_pay_element_types_f_ddf_v petv
1372: WHERE petv.hxt_earning_category = 'OTH'
1373: AND petv.hxt_premium_type = 'FIXED'
1374: AND petv.element_type_id = c_element_type_id
1375: AND petv.effective_start_date <= p_effective_start_date

Line 1696: hxt_pay_element_types_f_ddf_v eltv,

1692: IS
1693: SELECT hrw.time_in, hrw.time_out, hrw.hours, hrw.element_type_id,
1694: hrw.date_worked, eltv.hxt_earning_category
1695: FROM hxt_det_hours_worked hrw,
1696: hxt_pay_element_types_f_ddf_v eltv,
1697: pay_element_types_f elt
1698: WHERE elt.element_type_id = hrw.element_type_id
1699: AND eltv.hxt_earning_category IN ('REG', 'OVT', 'ABS')
1700: AND hrw.date_worked BETWEEN elt.effective_start_date

Line 1697: pay_element_types_f elt

1693: SELECT hrw.time_in, hrw.time_out, hrw.hours, hrw.element_type_id,
1694: hrw.date_worked, eltv.hxt_earning_category
1695: FROM hxt_det_hours_worked hrw,
1696: hxt_pay_element_types_f_ddf_v eltv,
1697: pay_element_types_f elt
1698: WHERE elt.element_type_id = hrw.element_type_id
1699: AND eltv.hxt_earning_category IN ('REG', 'OVT', 'ABS')
1700: AND hrw.date_worked BETWEEN elt.effective_start_date
1701: AND elt.effective_end_date

Line 1719: hxt_pay_element_types_f_ddf_v eltv,

1715: IS
1716: SELECT hrw.time_in, hrw.time_out, hrw.hours, hrw.element_type_id,
1717: hrw.date_worked, eltv.hxt_earning_category
1718: FROM hxt_det_hours_worked_f hrw,
1719: hxt_pay_element_types_f_ddf_v eltv,
1720: pay_element_types_f elt
1721: WHERE elt.element_type_id = hrw.element_type_id
1722: AND eltv.hxt_earning_category IN ('REG', 'OVT', 'ABS')
1723: AND c_session_date BETWEEN hrw.effective_start_date

Line 1720: pay_element_types_f elt

1716: SELECT hrw.time_in, hrw.time_out, hrw.hours, hrw.element_type_id,
1717: hrw.date_worked, eltv.hxt_earning_category
1718: FROM hxt_det_hours_worked_f hrw,
1719: hxt_pay_element_types_f_ddf_v eltv,
1720: pay_element_types_f elt
1721: WHERE elt.element_type_id = hrw.element_type_id
1722: AND eltv.hxt_earning_category IN ('REG', 'OVT', 'ABS')
1723: AND c_session_date BETWEEN hrw.effective_start_date
1724: AND hrw.effective_end_date