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 89: hxt_per_aei_ddf_v aeiv,

85: FROM per_time_periods ptp,
86: hxt_timecards tim,
87: per_people_f ppl,
88: hxt_earning_policies egp,
89: hxt_per_aei_ddf_v aeiv,
90: per_assignment_status_types ast,
91: per_assignments_f asm
92: WHERE ptp.payroll_id = asm.payroll_id
93: AND ast.assignment_status_type_id = asm.assignment_status_type_id

Line 178: hxt_per_aei_ddf_v aeiv,

174: FROM per_time_periods ptp,
175: hxt_timecards_f tim,
176: per_people_f ppl,
177: hxt_earning_policies egp,
178: hxt_per_aei_ddf_v aeiv,
179: per_assignment_status_types ast,
180: per_assignments_f asm
181: WHERE ptp.payroll_id = asm.payroll_id
182: AND session_date BETWEEN tim.effective_start_date(+)

Line 1381: hxt_per_aei_ddf_v aeiv,

1377: )
1378: AND NOT EXISTS (
1379: SELECT 'x'
1380: FROM per_time_periods ptp,
1381: hxt_per_aei_ddf_v aeiv,
1382: per_assignments_f asm
1383: WHERE asm.person_id = tim.for_person_id
1384: AND ptp.start_date
1385: BETWEEN asm.effective_start_date

Line 1474: hxt_per_aei_ddf_v asmv,

1470: -- so there might still be an issue when an assignment switches from autogen
1471: -- to no-autogen mid-period. We will need to look at this later.
1472: AND EXISTS ( SELECT 'x'
1473: FROM per_time_periods ptp,
1474: hxt_per_aei_ddf_v asmv,
1475: per_assignments_f asm
1476: WHERE asm.person_id = tim.for_person_id
1477: -- next 2 lines copied from g_cur_asm
1478: AND asm.effective_start_date <= ptp.end_date