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.

[Home] [Help]

APPS.HXT_TD_UTIL dependencies on HXT_EARN_GROUP_TYPES

Line 286: hxt_earn_group_types egt,

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
290:

Line 381: hxt_earn_group_types egt,

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
385:

Line 472: FROM hxt_earn_group_types egt

468: END IF;
469:
470: SELECT 1
471: INTO returned_element
472: FROM hxt_earn_group_types egt
473: WHERE egt.fcl_eg_type = 'INCLUDE'
474: AND a_date_worked BETWEEN egt.effective_start_date
475: AND egt.effective_end_date
476: AND egt.id = a_earn_group