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 79: FROM per_time_periods ptp,

75: tim.id tim_id, tim.batch_id, tim.auto_gen_flag,
76: egp.fcl_earn_type egp_type, egp.egt_id, egp.hcl_id, egp.pep_id,
77: egp.pip_id, ptp.ROWID ptp_rowid, egp.effective_start_date,
78: egp.effective_end_date
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,

Line 1247: FROM per_time_periods ptp,

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

Line 1340: FROM per_time_periods ptp,

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