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 PER_TIME_PERIODS

Line 85: FROM per_time_periods ptp,

81: tim.id tim_id, tim.batch_id, tim.auto_gen_flag,
82: egp.fcl_earn_type egp_type, egp.egt_id, egp.hcl_id, egp.pep_id,
83: egp.pip_id, ptp.ROWID ptp_rowid, egp.effective_start_date,
84: egp.effective_end_date
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,

Line 174: FROM per_time_periods ptp,

170: tim.id tim_id, tim.batch_id, tim.auto_gen_flag,
171: egp.fcl_earn_type egp_type, egp.egt_id, egp.hcl_id, egp.pep_id,
172: egp.pip_id, ptp.ROWID ptp_rowid, egp.effective_start_date,
173: egp.effective_end_date
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,

Line 1380: FROM per_time_periods ptp,

1376: OR tim.batch_id is null -- added 2772781
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

Line 1473: FROM per_time_periods ptp,

1469: -- multiple records, one for every datetrack update on the assignment or aei
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