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 PER_ASSIGNMENTS_F

Line 866: per_assignments_f asm,

862: FROM hxt_pay_element_types_f_ddf_v eltv,
863: pay_element_types_f elt,
864: hxt_earning_policies egp,
865: hxt_per_aei_ddf_v asmv,
866: per_assignments_f asm,
867: hxt_det_hours_worked hrw,
868: hxt_timecards tim
869: WHERE hrw.parent_id > 0
870: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,

Line 917: per_assignments_f asm,

913: FROM hxt_pay_element_types_f_ddf_v eltv,
914: pay_element_types_f elt,
915: hxt_earning_policies egp,
916: hxt_per_aei_ddf_v asmv,
917: per_assignments_f asm,
918: hxt_det_hours_worked_f hrw,
919: hxt_timecards_f tim
920: WHERE hrw.parent_id > 0
921: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,

Line 998: per_assignments_f asm,

994: pay_element_types_f elt,
995: hxt_earn_groups erg,
996: hxt_earning_policies egp,
997: hxt_per_aei_ddf_v asmv,
998: per_assignments_f asm,
999: hxt_det_hours_worked hrw,
1000: hxt_timecards tim
1001: WHERE hrw.parent_id > 0
1002: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,

Line 1038: per_assignments_f asm,

1034: pay_element_types_f elt,
1035: hxt_earn_groups erg,
1036: hxt_earning_policies egp,
1037: hxt_per_aei_ddf_v asmv,
1038: per_assignments_f asm,
1039: hxt_det_hours_worked_f hrw,
1040: hxt_timecards_f tim
1041: WHERE hrw.parent_id > 0
1042: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,

Line 1109: per_assignments_f asm,

1105: FROM hxt_pay_element_types_f_ddf_v eltv,
1106: pay_element_types_f elt,
1107: hxt_earning_policies egp,
1108: hxt_per_aei_ddf_v asmv,
1109: per_assignments_f asm,
1110: hxt_det_hours_worked hrw,
1111: hxt_timecards tim
1112: WHERE hrw.parent_id > 0
1113: AND hrw.date_worked = g_date_worked

Line 1159: per_assignments_f asm,

1155: FROM hxt_pay_element_types_f_ddf_v eltv,
1156: pay_element_types_f elt,
1157: hxt_earning_policies egp,
1158: hxt_per_aei_ddf_v asmv,
1159: per_assignments_f asm,
1160: hxt_det_hours_worked_f hrw,
1161: hxt_timecards_f tim
1162: WHERE hrw.parent_id > 0
1163: AND hrw.date_worked = g_date_worked

Line 1477: per_assignments_f asm,

1473: FROM hxt_pay_element_types_f_ddf_v eltv,
1474: pay_element_types_f elt,
1475: hxt_earning_policies egp,
1476: hxt_per_aei_ddf_v asmv,
1477: per_assignments_f asm,
1478: hxt_det_hours_worked hrw,
1479: hxt_timecards tim
1480: WHERE hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
1481: start_day_of_week

Line 1526: per_assignments_f asm,

1522: FROM hxt_pay_element_types_f_ddf_v eltv,
1523: pay_element_types_f elt,
1524: hxt_earning_policies egp,
1525: hxt_per_aei_ddf_v asmv,
1526: per_assignments_f asm,
1527: hxt_det_hours_worked_f hrw,
1528: hxt_timecards_f tim
1529: WHERE hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
1530: start_day_of_week