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_TIME_SUMMARY dependencies on HXT_EARNING_RULES

Line 526: hxt_earning_rules er

522: IS SELECT hours,
523: hours- NVL(LAG(hours) OVER (ORDER BY hours) ,0) cap,
524: element_type_id
525: FROM hxt_earning_policies ep,
526: hxt_earning_rules er
527: WHERE ep.id = p_ep_id
528: AND er.egp_id = ep.id
529: AND g_sum_session_date BETWEEN er.effective_start_date
530: AND er.effective_end_date

Line 538: FROM hxt_earning_rules er,

534: CURSOR get_reg_elements(p_ep_id IN NUMBER,
535: p_date IN DATE)
536: IS SELECT DISTINCT
537: er.element_type_id
538: FROM hxt_earning_rules er,
539: hxt_pay_element_types_f_ddf_v elem
540: WHERE er.egp_id = p_ep_id
541: AND p_date BETWEEN er.effective_start_date
542: AND er.effective_end_date

Line 579: hxt_earning_rules er,

575: IS
576: SELECT NVL(SUM(det.hours),0)
577: FROM hxt_det_hours_worked_f det,
578: hxt_sum_hours_worked_f sum,
579: hxt_earning_rules er,
580: hxt_pay_element_types_f_ddf_v elem
581: WHERE det.tim_id = g_hol_tim_id
582: AND sum.id = det.parent_id
583: AND g_sum_session_date BETWEEN sum.effective_start_date

Line 4311: hxt_earning_rules er

4307:
4308: CURSOR get_max_hours(p_ep_id IN NUMBER)
4309: IS SELECT max(hours)
4310: FROM hxt_earning_policies ep,
4311: hxt_earning_rules er
4312: WHERE ep.id = p_ep_id
4313: AND g_sum_session_date BETWEEN ep.effective_start_date
4314: AND ep.effective_end_date
4315: AND ep.fcl_earn_type = 'SPECIAL'