APPS.HXT_RETRO_MIX dependencies on HXT_DET_HOURS_WORKED_X

Line 1089: hxt_det_hours_worked_x hrw,

1085: hsw.attribute14,
1086: hsw.attribute15
1087: FROM hxt_timecards_x tim,
1088: per_time_periods ptp,
1089: hxt_det_hours_worked_x hrw,
1090: hxt_sum_hours_worked_x hsw,
1091: hr_lookups hcl, --GLOBAL
1092: per_assignments_f asm,
1093: pay_element_types_f elt,

Line 1221: hxt_det_hours_worked_x hrw,

1217: hrw.city_name,
1218: hrw.zip_code
1219: FROM hxt_timecards_x tim,
1220: per_time_periods ptp,
1221: hxt_det_hours_worked_x hrw,
1222: hr_lookups hcl, --GLOBAL
1223: per_assignments_f asm,
1224: pay_element_types_f elt,
1225: pay_cost_allocation_keyflex pcak,

Line 2222: FROM hxt_det_hours_worked_x retro

2218: AND hrw.pay_status = 'C'
2219: AND hrw.amount IS NULL
2220: AND hrw.parent_id > 0
2221: AND EXISTS ( SELECT 'X'
2222: FROM hxt_det_hours_worked_x retro
2223: WHERE hrw.parent_id = retro.parent_id
2224: AND retro.pay_status = 'R'
2225: AND hrw.hours = retro.hours
2226: AND hrw.amount IS NULL

Line 2301: FROM hxt_det_hours_worked_x retro

2297: AND hrw.pay_status = 'C'
2298: AND hrw.amount IS NULL
2299: AND hrw.parent_id > 0
2300: AND EXISTS ( SELECT 'X'
2301: FROM hxt_det_hours_worked_x retro
2302: WHERE hrw.parent_id = retro.parent_id
2303: AND retro.pay_status = 'R'
2304: AND hrw.hours <> retro.hours
2305: AND hrw.amount IS NULL

Line 2384: FROM hxt_det_hours_worked_x retro

2380: AND hrw.pay_status = 'C'
2381: AND hrw.amount IS NOT NULL
2382: AND hrw.parent_id > 0
2383: AND EXISTS ( SELECT 'X'
2384: FROM hxt_det_hours_worked_x retro
2385: WHERE hrw.parent_id = retro.parent_id
2386: AND retro.pay_status = 'R'
2387: AND hrw.amount = retro.amount
2388: AND hrw.amount IS NOT NULL

Line 2464: FROM hxt_det_hours_worked_x retro

2460: AND hrw.pay_status = 'C'
2461: AND hrw.amount IS NOT NULL
2462: AND hrw.parent_id > 0
2463: AND EXISTS ( SELECT 'X'
2464: FROM hxt_det_hours_worked_x retro
2465: WHERE hrw.parent_id = retro.parent_id
2466: AND retro.pay_status = 'R'
2467: AND hrw.amount <> retro.amount
2468: AND hrw.amount IS NOT NULL

Line 2541: FROM hxt_det_hours_worked_x hrw

2537: UPDATE hxt_det_hours_worked_f
2538: SET pay_status = 'C',
2539: last_update_date = SYSDATE
2540: WHERE ROWID IN (SELECT hrw.ROWID
2541: FROM hxt_det_hours_worked_x hrw
2542: WHERE hrw.parent_id > 0
2543: AND hrw.pay_status = 'R'
2544: AND hrw.tim_id = p_tim_id);
2545: END mark_retro_rows_complete;