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_COLLECTION dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 42: per_assignment_status_types ast,

38: SELECT asm.payroll_id, asm.assignment_id, asm.effective_start_date,
39: asm.effective_end_date, asmv.hxt_rotation_plan, egp.hcl_id
40: FROM hxt_earning_policies egp,
41: hxt_per_aei_ddf_v asmv,
42: per_assignment_status_types ast,
43: per_all_assignments_f asm
44: WHERE c_person_id = asm.person_id
45: AND asm.primary_flag = 'Y'
46: AND TRUNC (c_date_worked) BETWEEN TRUNC (asm.effective_start_date)

Line 64: per_assignment_status_types ast,

60: SELECT asmv.hxt_earning_policy, asmv.hxt_shift_differential_policy,
61: asmv.hxt_hour_deduction_policy, wsh.off_shift_prem_id,
62: wsh.shift_diff_ovrrd_id
63: FROM hxt_per_aei_ddf_v asmv,
64: per_assignment_status_types ast,
65: per_assignments_f asm,
66: hxt_shifts sht,
67: hxt_weekly_work_schedules wws,
68: hxt_work_shifts wsh,