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_UTIL dependencies on PAY_ELEMENT_TYPES_F

Line 470: FROM hxt_pay_element_types_f_ddf_v eltv

466: BEGIN
467: BEGIN
468: SELECT eltv.hxt_earning_category
469: INTO l_earning_cat
470: FROM hxt_pay_element_types_f_ddf_v eltv
471: WHERE eltv.element_type_id = p_element_type_id
472: AND p_date_worked BETWEEN eltv.effective_start_date
473: AND eltv.effective_end_date;
474: EXCEPTION

Line 1596: PAY_ELEMENT_TYPES_F PETF,

1592: SELECT
1593: PAP.ACCRUAL_PLAN_ID,
1594: PAP.ACCRUAL_CATEGORY
1595: FROM
1596: PAY_ELEMENT_TYPES_F PETF,
1597: PAY_ELEMENT_CLASSIFICATIONS PEC,
1598: PAY_ELEMENT_ENTRIES_F PEEF,
1599: PAY_ELEMENT_LINKS_F PELF,
1600: PAY_ACCRUAL_PLANS PAP

Line 1758: pay_element_types_f pef,

1754:
1755: SELECT /*+ ORDERED */
1756: SUM(hrw.hours*(-1)*(ncr.add_or_subtract))
1757: FROM hxt_sum_hours_worked_f hrw,
1758: pay_element_types_f pef,
1759: pay_input_values_f piv,
1760: pay_net_calculation_rules ncr
1761: WHERE hrw.tim_id = p_tim_id
1762: AND SYSDATE BETWEEN hrw.effective_start_date