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 HXT_BATCH_STATES

Line 2941: hxt_batch_states tbh,

2937: )
2938: IS
2939: SELECT tim.for_person_id, tbh.status, ptp.start_date --SIR286
2940: FROM hxt_timecards tim, --SIR290
2941: hxt_batch_states tbh,
2942: per_time_periods ptp --SIR286
2943: WHERE tim.ID = c_tim_id
2944: AND tbh.batch_id = tim.batch_id
2945: AND ptp.time_period_id = tim.time_period_id -- SIR286

Line 3258: FROM hxt_batch_states

3254: IS
3255: BEGIN
3256: SELECT status
3257: INTO o_batch_status
3258: FROM hxt_batch_states
3259: WHERE batch_id = i_batch_id;
3260:
3261: RETURN 0;
3262: EXCEPTION

Line 3671: hxt_batch_states hbs,

3667: )
3668: IS
3669: SELECT COUNT (ht.ID) num_tcs, MAX (ht.batch_id) batch_id
3670: FROM hxt_timecards ht,
3671: hxt_batch_states hbs,
3672: pay_batch_headers pbh
3673: WHERE ht.time_period_id = p_time_period_id
3674: AND hbs.batch_id = ht.batch_id
3675: AND pbh.batch_id = ht.batch_id