APPS.HXT_RETRO_MIX dependencies on HXT_SUM_HOURS_WORKED_F

Line 1314: hxt_sum_hours_worked_f hsw,

1310: SELECT hrw.hours hours_worked, hrw.ROWID hrw_rowid -- OHM199
1311: FROM hxt_timecards_x tim,
1312: per_time_periods ptp,
1313: hxt_det_hours_worked_f hrw,
1314: hxt_sum_hours_worked_f hsw,
1315: per_assignments_f asm,
1316: pay_element_types_f elt
1317: WHERE hrw.assignment_id = p_assignment_id
1318: AND asm.assignment_id = hrw.assignment_id

Line 2570: FROM hxt_sum_hours_worked_f

2566: attribute12,
2567: attribute13,
2568: attribute14,
2569: attribute15
2570: FROM hxt_sum_hours_worked_f
2571: WHERE id = p_id
2572: AND effective_end_date <> hr_general.end_of_time
2573: ORDER BY effective_end_date DESC;
2574:

Line 3422: hxt_sum_hours_worked_f sum,

3418: det.retro_batch_id,
3419: det.hours,
3420: ROWIDTOCHAR(ret.ROWID)
3421: FROM hxt_det_hours_worked_f det,
3422: hxt_sum_hours_worked_f sum,
3423: hxc_ret_pay_latest_details ret
3424: WHERE det.tim_id = p_tim_id
3425: AND det.effective_end_date = hr_general.end_of_time
3426: AND sum.id = det.parent_id

Line 3540: hxt_sum_hours_worked_f sum,

3536: RANK() OVER (PARTITION BY ret.time_building_block_id,
3537: ret.object_version_number
3538: ORDER BY ret.ROWID) rank
3539: FROM hxt_det_hours_worked_f det,
3540: hxt_sum_hours_worked_f sum,
3541: hxc_ret_pay_latest_details ret
3542: WHERE det.parent_id = sum.id
3543: AND det.tim_id = p_tim_id
3544: AND det.hours <> 0

Line 3594: hxt_sum_hours_worked_f sum,

3590: ret.retro_batch_id,
3591: ret.old_batch_id,
3592: ROWIDTOCHAR(ret.ROWID)
3593: FROM hxt_det_hours_worked_f det,
3594: hxt_sum_hours_worked_f sum,
3595: hxc_ret_pay_latest_details ret
3596: WHERE det.tim_id = p_tim_id
3597: AND det.effective_end_date = hr_general.end_of_time
3598: AND det.retro_batch_id = p_batch_id

Line 3929: hxt_sum_hours_worked_f sum,

3925: CURSOR get_backouts_not_touched_now
3926: IS SELECT ROWIDTOCHAR(ret.rowid),
3927: det.retro_pbl_line_id
3928: FROM hxt_det_hours_worked_f det,
3929: hxt_sum_hours_worked_f sum,
3930: pay_batch_lines pbl,
3931: hxc_ret_pay_latest_details ret
3932: WHERE pbl.batch_id = p_batch_id
3933: AND pbl.batch_line_id = det.retro_pbl_line_id

Line 3948: hxt_sum_hours_worked_f sum,

3944: CURSOR get_backouts_touched_now
3945: IS SELECT ROWIDTOCHAR(ret.rowid),
3946: det.retro_pbl_line_id
3947: FROM hxt_det_hours_worked_f det,
3948: hxt_sum_hours_worked_f sum,
3949: pay_batch_lines pbl,
3950: hxc_ret_pay_latest_details ret
3951: WHERE pbl.batch_id = p_batch_id
3952: AND pbl.batch_line_id = det.retro_pbl_line_id

Line 3968: hxt_sum_hours_worked_f sum,

3964:
3965: CURSOR get_changed_hours
3966: IS SELECT ROWIDTOCHAR(ret.rowid)
3967: FROM hxt_det_hours_worked_f det,
3968: hxt_sum_hours_worked_f sum,
3969: hxc_ret_pay_latest_details ret
3970: WHERE det.retro_batch_id = p_batch_id
3971: AND det.pay_status = 'C'
3972: AND det.tim_id = p_tim_id

Line 4054: hxt_sum_hours_worked_f sum,

4050: NULL retro_batch_id,
4051: NULL old_batch_id,
4052: ret.application_set_id
4053: FROM hxt_det_hours_worked_f det,
4054: hxt_sum_hours_worked_f sum,
4055: hxc_ret_pay_latest_details ret,
4056: pay_batch_lines pbl
4057: WHERE det.retro_batch_id = p_batch_id
4058: AND det.retro_pbl_line_id IS NOT NULL

Line 4079: FROM hxt_sum_hours_worked_f sum,

4075: ret.measure,
4076: ret.attribute1,
4077: ret.attribute2,
4078: ret.attribute3
4079: FROM hxt_sum_hours_worked_f sum,
4080: hxc_ret_pay_latest_details ret
4081: WHERE sum.tim_id = p_tim_id
4082: AND ret.time_building_block_id = sum.time_building_block_id
4083: AND ret.batch_id = p_batch_id