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_PAY dependencies on PAY_ELEMENT_TYPES_F_TL

Line 855: pay_element_types_f_tl eltt,

851: eltv.hxt_processing_order
852: FROM pay_element_links_f ell,
853: hxt_pay_element_types_f_ddf_v eltv,
854: pay_element_types_f elt,
855: pay_element_types_f_tl eltt,
856: hxt_prem_eligblty_rules per,
857: per_all_assignments_f asm
858: WHERE asm.assignment_id = g_ASSIGNMENT_ID
859: AND g_DATE_WORKED between asm.effective_start_date

Line 926: ,pay_element_types_f_tl eltt

922: ,eltv.hxt_premium_amount
923: ,eltv.hxt_processing_order
924: FROM hxt_pay_element_types_f_ddf_v eltv
925: ,pay_element_types_f elt
926: ,pay_element_types_f_tl eltt
927: WHERE elt.element_type_id = p_element_type_id
928: AND g_DATE_WORKED between elt.effective_start_date
929: and elt.effective_end_date
930: AND eltt.element_type_id = elt.element_type_id

Line 995: pay_element_types_f_tl eltt,

991: eltv.hxt_earning_category,
992: eltv.hxt_premium_type
993: FROM hxt_pay_element_types_f_ddf_v eltv,
994: pay_element_types_f elt,
995: pay_element_types_f_tl eltt,
996: hxt_prem_interact_rules pir,
997: hxt_det_hours_worked hrw -- C421
998: WHERE hrw.tim_id = g_TIM_ID
999: AND hrw.date_worked = g_DATE_WORKED

Line 1059: pay_element_types_f_tl eltt,

1055: eltv.hxt_earning_category,
1056: eltv.hxt_premium_type
1057: FROM hxt_pay_element_types_f_ddf_v eltv,
1058: pay_element_types_f elt,
1059: pay_element_types_f_tl eltt,
1060: hxt_prem_interact_rules pir,
1061: hxt_det_hours_worked_f hrw -- C421
1062: WHERE hrw.tim_id = g_TIM_ID
1063: AND hrw.date_worked = g_DATE_WORKED