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

Line 83: hxt_per_aei_ddf_v aeiv,

79: FROM per_time_periods ptp,
80: hxt_timecards tim,
81: per_people_f ppl,
82: hxt_earning_policies egp,
83: hxt_per_aei_ddf_v aeiv,
84: per_assignment_status_types ast,
85: per_assignments_f asm
86: WHERE ptp.payroll_id = asm.payroll_id
87: AND ast.assignment_status_type_id = asm.assignment_status_type_id

Line 1248: hxt_per_aei_ddf_v aeiv,

1244: )
1245: AND NOT EXISTS (
1246: SELECT 'x'
1247: FROM per_time_periods ptp,
1248: hxt_per_aei_ddf_v aeiv,
1249: per_assignments_f asm
1250: WHERE asm.person_id = tim.for_person_id
1251: AND ptp.start_date
1252: BETWEEN asm.effective_start_date

Line 1341: hxt_per_aei_ddf_v asmv,

1337: -- so there might still be an issue when an assignment switches from autogen
1338: -- to no-autogen mid-period. We will need to look at this later.
1339: AND EXISTS ( SELECT 'x'
1340: FROM per_time_periods ptp,
1341: hxt_per_aei_ddf_v asmv,
1342: per_assignments_f asm
1343: WHERE asm.person_id = tim.for_person_id
1344: -- next 2 lines copied from g_cur_asm
1345: AND asm.effective_start_date <= ptp.end_date