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_BATCH_STATES

Line 132: select '1' from HXT_BATCH_STATES -- added 2772781

128: AND ptp.time_period_id = a_time_period_id
129: AND ptp.payroll_id = a_payroll_id
130: AND not exists -- added 2772781
131: ( -- added 2772781
132: select '1' from HXT_BATCH_STATES -- added 2772781
133: where (hxt_batch_states.STATUS ='VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781
134: ) -- added 2772781
135: ORDER BY tim.batch_id,
136: ppl.person_id,

Line 133: where (hxt_batch_states.STATUS ='VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781

129: AND ptp.payroll_id = a_payroll_id
130: AND not exists -- added 2772781
131: ( -- added 2772781
132: select '1' from HXT_BATCH_STATES -- added 2772781
133: where (hxt_batch_states.STATUS ='VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781
134: ) -- added 2772781
135: ORDER BY tim.batch_id,
136: ppl.person_id,
137: asm.assignment_number,

Line 221: select '1' from HXT_BATCH_STATES -- added 2772781

217: AND ptp.time_period_id = a_time_period_id
218: AND ptp.payroll_id = a_payroll_id
219: AND not exists -- added 2772781
220: ( -- added 2772781
221: select '1' from HXT_BATCH_STATES -- added 2772781
222: where (hxt_batch_states.STATUS ='VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781
223: ) -- added 2772781
224: ORDER BY tim.batch_id,
225: ppl.person_id,

Line 222: where (hxt_batch_states.STATUS ='VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781

218: AND ptp.payroll_id = a_payroll_id
219: AND not exists -- added 2772781
220: ( -- added 2772781
221: select '1' from HXT_BATCH_STATES -- added 2772781
222: where (hxt_batch_states.STATUS ='VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781
223: ) -- added 2772781
224: ORDER BY tim.batch_id,
225: ppl.person_id,
226: asm.assignment_number,

Line 1374: select '1' from HXT_BATCH_STATES -- added 2772781

1370: WHERE tim.auto_gen_flag = 'A'
1371: AND tim.time_period_id = g_time_period_id
1372: AND exists -- added 2772781
1373: (
1374: select '1' from HXT_BATCH_STATES -- added 2772781
1375: where (hxt_batch_states.STATUS <>'VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781
1376: OR tim.batch_id is null -- added 2772781
1377: )
1378: AND NOT EXISTS (

Line 1375: where (hxt_batch_states.STATUS <>'VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781

1371: AND tim.time_period_id = g_time_period_id
1372: AND exists -- added 2772781
1373: (
1374: select '1' from HXT_BATCH_STATES -- added 2772781
1375: where (hxt_batch_states.STATUS <>'VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781
1376: OR tim.batch_id is null -- added 2772781
1377: )
1378: AND NOT EXISTS (
1379: SELECT 'x'