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_RETRO_MIX dependencies on HR_GENERAL

Line 2572: AND effective_end_date <> hr_general.end_of_time

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:
2575: CURSOR leftover_hours (p_tim_id NUMBER)
2576: IS

Line 2705: AND hrw.effective_end_date < hr_general.end_of_time; --SIR149 --FORMS60

2701: AND hcl.lookup_code(+) = hrw.fcl_earn_reason_code
2702:
2703: --END GLOBAL
2704: AND hrw.pay_status = 'C'
2705: AND hrw.effective_end_date < hr_general.end_of_time; --SIR149 --FORMS60
2706:
2707:
2708: --BSE128 l_leftover leftover_hours %ROWTYPE;
2709: -- l_nextval NUMBER (15);

Line 3198: AND hrw.effective_end_date < hr_general.end_of_time; --SIR149 --FORMS60

3194: AND hcl.lookup_code(+) = hrw.fcl_earn_reason_code
3195:
3196: --END GLOBAL
3197: AND hrw.pay_status = 'C'
3198: AND hrw.effective_end_date < hr_general.end_of_time; --SIR149 --FORMS60
3199:
3200: l_leftover leftover_amount%ROWTYPE;
3201: -- l_nextval NUMBER (15);
3202: l_batch_line_id NUMBER (15);

Line 3381: AND det.effective_end_date <> hr_general.end_of_time

3377: FROM hxt_det_hours_worked_f det,
3378: hxc_ret_pay_latest_details ret,
3379: pay_batch_lines pbl
3380: WHERE det.pay_status = 'B'
3381: AND det.effective_end_date <> hr_general.end_of_time
3382: AND det.pbl_line_id = ret.old_pbl_id
3383: AND ret.retro_batch_id IS NULL
3384: AND det.tim_id = p_tim_id
3385: AND pbl.batch_id = p_batch_id

Line 3406: AND det.effective_end_date <> hr_general.end_of_time

3402: FROM hxt_det_hours_worked_f det,
3403: hxc_ret_pay_latest_details ret,
3404: pay_batch_lines pbl
3405: WHERE det.pay_status = 'B'
3406: AND det.effective_end_date <> hr_general.end_of_time
3407: AND det.pbl_line_id = ret.pbl_id
3408: AND ret.retro_batch_id IS NULL
3409: AND det.tim_id = p_tim_id
3410: AND pbl.batch_id = p_batch_id

Line 3425: AND det.effective_end_date = hr_general.end_of_time

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
3427: AND sum.effective_end_date = hr_general.end_of_time
3428: AND det.retro_pbl_line_id IS NOT NULL
3429: AND det.retro_batch_id = p_batch_id

Line 3427: AND sum.effective_end_date = hr_general.end_of_time

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
3427: AND sum.effective_end_date = hr_general.end_of_time
3428: AND det.retro_pbl_line_id IS NOT NULL
3429: AND det.retro_batch_id = p_batch_id
3430: AND ret.time_building_block_id = sum.time_building_block_id
3431: AND ret.object_version_number = sum.time_building_block_ovn

Line 3546: AND det.effective_end_date = hr_general.end_of_time

3542: WHERE det.parent_id = sum.id
3543: AND det.tim_id = p_tim_id
3544: AND det.hours <> 0
3545: AND det.retro_batch_id = p_batch_id
3546: AND det.effective_end_date = hr_general.end_of_time
3547: AND sum.effective_end_date = hr_general.end_of_time
3548: AND sum.time_building_block_id = ret.time_building_block_id
3549: AND sum.time_building_block_ovn = ret.object_version_number
3550: AND (ret.batch_id IS NOT NULL

Line 3547: AND sum.effective_end_date = hr_general.end_of_time

3543: AND det.tim_id = p_tim_id
3544: AND det.hours <> 0
3545: AND det.retro_batch_id = p_batch_id
3546: AND det.effective_end_date = hr_general.end_of_time
3547: AND sum.effective_end_date = hr_general.end_of_time
3548: AND sum.time_building_block_id = ret.time_building_block_id
3549: AND sum.time_building_block_ovn = ret.object_version_number
3550: AND (ret.batch_id IS NOT NULL
3551: OR ret.retro_batch_id IS NOT NULL

Line 3597: AND det.effective_end_date = hr_general.end_of_time

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
3599: AND det.parent_id = sum.id
3600: AND sum.effective_end_date = hr_general.end_of_time
3601: AND sum.time_building_block_id = ret.time_building_block_id

Line 3600: AND sum.effective_end_date = hr_general.end_of_time

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
3599: AND det.parent_id = sum.id
3600: AND sum.effective_end_date = hr_general.end_of_time
3601: AND sum.time_building_block_id = ret.time_building_block_id
3602: AND sum.time_building_block_ovn = ret.object_version_number
3603: AND det.retro_pbl_line_id IS NOT NULL
3604: AND ret.pbl_id IS NULL