APPS.HXT_TIME_GEN dependencies on HXT_BATCH_STATES

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

122: AND ptp.time_period_id = a_time_period_id
123: AND ptp.payroll_id = a_payroll_id
124: AND not exists -- added 2772781
125: ( -- added 2772781
126: select '1' from HXT_BATCH_STATES -- added 2772781
127: where (hxt_batch_states.STATUS ='VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781
128: ) -- added 2772781
129: ORDER BY tim.batch_id,
130: ppl.person_id,

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

123: AND ptp.payroll_id = a_payroll_id
124: AND not exists -- added 2772781
125: ( -- added 2772781
126: select '1' from HXT_BATCH_STATES -- added 2772781
127: where (hxt_batch_states.STATUS ='VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781
128: ) -- added 2772781
129: ORDER BY tim.batch_id,
130: ppl.person_id,
131: asm.assignment_number,

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

1237: WHERE tim.auto_gen_flag = 'A'
1238: AND tim.time_period_id = g_time_period_id
1239: AND exists -- added 2772781
1240: (
1241: select '1' from HXT_BATCH_STATES -- added 2772781
1242: where (hxt_batch_states.STATUS <>'VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781
1243: OR tim.batch_id is null -- added 2772781
1244: )
1245: AND NOT EXISTS (

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

1238: AND tim.time_period_id = g_time_period_id
1239: AND exists -- added 2772781
1240: (
1241: select '1' from HXT_BATCH_STATES -- added 2772781
1242: where (hxt_batch_states.STATUS <>'VT' and hxt_batch_states.batch_id=tim.batch_id) -- added 2772781
1243: OR tim.batch_id is null -- added 2772781
1244: )
1245: AND NOT EXISTS (
1246: SELECT 'x'