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 HXT_EARN_GROUPS

Line 285: hxt_earn_groups erg,

281: IS
282: SELECT NVL (SUM (hrw.hours), 0)
283: FROM hxt_det_hours_worked hrw, --C421
284: hxt_timecards tim,
285: hxt_earn_groups erg,
286: hxt_earn_group_types egt,
287: hxt_earning_policies erp
288: -- WHERE tim.id = a_tim_id
289: -- AND hrw.tim_id = a_tim_id

Line 380: hxt_earn_groups erg,

376: IS
377: SELECT NVL (SUM (hrw.hours), 0)
378: FROM hxt_det_hours_worked hrw, --C421
379: hxt_timecards tim,
380: hxt_earn_groups erg,
381: hxt_earn_group_types egt,
382: hxt_earning_policies erp
383: -- WHERE tim.id = a_tim_id
384: -- AND hrw.tim_id = a_tim_id

Line 478: FROM hxt_earn_groups egr

474: AND a_date_worked BETWEEN egt.effective_start_date
475: AND egt.effective_end_date
476: AND egt.id = a_earn_group
477: AND EXISTS ( SELECT 'x'
478: FROM hxt_earn_groups egr
479: WHERE egr.egt_id = egt.id
480: AND egr.element_type_id = a_element_type);
481:
482: IF returned_element = 1