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.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXT_BATCH_VALUES_V

Line 2816: FROM hxt_batch_values_v

2812: IS
2813: CURSOR get_batch_rec
2814: IS
2815: SELECT *
2816: FROM hxt_batch_values_v
2817: WHERE (date_worked ,assignment_id) in
2818: ( SELECT date_earned,
2819: paf.assignment_id
2820: FROM hxc_bee_pref_adj_lines hoa,

Line 2826: p_batch_rec hxt_batch_values_v%ROWTYPE;

2822: WHERE hoa.resource_id = paf.person_id
2823: AND hoa.date_earned BETWEEN paf.effective_start_date
2824: AND paf.effective_end_date
2825: AND paf.primary_flag = 'Y');
2826: p_batch_rec hxt_batch_values_v%ROWTYPE;
2827: l_sum_retcode NUMBER := 0;
2828: l_batch_sequence NUMBER;
2829:
2830: BEGIN

Line 2858: -- HXT_BATCH_VALUES_V. There could have been a timecard edit in HXT, and the changed

2854: -- In case the timecard is still with HXT, no need to create reversal batches.
2855: -- But see that they are deleted from the system, so that they can never be
2856: -- transferred. Delete the non transferred hours first.
2857: -- Create a batch header, and then create the batch lines taking values from
2858: -- HXT_BATCH_VALUES_V. There could have been a timecard edit in HXT, and the changed
2859: -- hours could have gone to BEE. The reversal batch lines has to reverse these, rather
2860: -- than the hours you pulled out from HXC. HXT_BATCH_VALUES_V is a view on hxt detail hours
2861: -- and pay batch lines, so what you get from there would be the transferred values.
2862: -- So after you pull out the batch records, turn around the hours with a negative sign

Line 2860: -- than the hours you pulled out from HXC. HXT_BATCH_VALUES_V is a view on hxt detail hours

2856: -- transferred. Delete the non transferred hours first.
2857: -- Create a batch header, and then create the batch lines taking values from
2858: -- HXT_BATCH_VALUES_V. There could have been a timecard edit in HXT, and the changed
2859: -- hours could have gone to BEE. The reversal batch lines has to reverse these, rather
2860: -- than the hours you pulled out from HXC. HXT_BATCH_VALUES_V is a view on hxt detail hours
2861: -- and pay batch lines, so what you get from there would be the transferred values.
2862: -- So after you pull out the batch records, turn around the hours with a negative sign
2863: -- and create the lines.
2864: delete_non_transferred_hours;