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_DETAIL dependencies on HXT_PER_AEI_DDF_V

Line 741: hxt_per_aei_ddf_v asmv,

737: SELECT NVL (SUM (hrw.hours), 0)
738: FROM hxt_pay_element_types_f_ddf_v eltv,
739: pay_element_types_f elt,
740: hxt_earning_policies egp,
741: hxt_per_aei_ddf_v asmv,
742: per_assignments_f asm,
743: hxt_det_hours_worked hrw,
744: hxt_timecards tim
745: WHERE hrw.parent_id > 0

Line 810: hxt_per_aei_ddf_v asmv,

806: FROM hxt_pay_element_types_f_ddf_v eltv,
807: pay_element_types_f elt,
808: hxt_earn_groups erg,
809: hxt_earning_policies egp,
810: hxt_per_aei_ddf_v asmv,
811: per_assignments_f asm,
812: hxt_det_hours_worked hrw,
813: hxt_timecards tim
814: WHERE hrw.parent_id > 0

Line 863: hxt_per_aei_ddf_v asmv,

859: SELECT NVL (SUM (hrw.hours), 0)
860: FROM hxt_pay_element_types_f_ddf_v eltv,
861: pay_element_types_f elt,
862: hxt_earning_policies egp,
863: hxt_per_aei_ddf_v asmv,
864: per_assignments_f asm,
865: hxt_det_hours_worked hrw,
866: hxt_timecards tim
867: WHERE hrw.parent_id > 0

Line 1092: hxt_per_aei_ddf_v asmv,

1088: SELECT NVL (SUM (hrw.hours), 0)
1089: FROM hxt_pay_element_types_f_ddf_v eltv,
1090: pay_element_types_f elt,
1091: hxt_earning_policies egp,
1092: hxt_per_aei_ddf_v asmv,
1093: per_assignments_f asm,
1094: hxt_det_hours_worked hrw,
1095: hxt_timecards tim
1096: WHERE hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,

Line 12650: hxt_per_aei_ddf_v aeiv,

12646: IS
12647: SELECT hws.off_shift_prem_id
12648: FROM hxt_shifts hs,
12649: hxt_work_shifts hws,
12650: hxt_per_aei_ddf_v aeiv,
12651: hxt_rotation_schedules hrs
12652: WHERE aeiv.assignment_id = p_assignment_id
12653: AND p_date_worked BETWEEN aeiv.effective_start_date
12654: AND aeiv.effective_end_date

Line 12673: FROM hxt_per_aei_ddf_v aeiv,

12669: INDEX(hrs hxt_rotation_schedules_pk)
12670: USE_NL(aeiv hrs)
12671: USE_NL(hrs hws) */
12672: hws.off_shift_prem_id
12673: FROM hxt_per_aei_ddf_v aeiv,
12674: hxt_rotation_schedules hrs,
12675: hxt_work_shifts hws,
12676: hxt_shifts hs
12677: WHERE aeiv.assignment_id = p_assignment_id