APPS.HXT_RETRIEVAL_ROLLBACK dependencies on HR_GENERAL

Line 646: decode(effective_end_date,hr_general.end_of_time,''A'',''I'') status,

642: l_sql VARCHAR2(4000) :=
643: ' select id,
644: parent_id,
645: date_worked,
646: decode(effective_end_date,hr_general.end_of_time,''A'',''I'') status,
647: hours,
648: element_type_id,
649: pay_status,
650: pbl_line_id,

Line 957: decode(effective_end_date,hr_general.end_of_time,''A'',''I'') status,

953: l_sql VARCHAR2(4000) :=
954: ' select id,
955: parent_id,
956: date_worked,
957: decode(effective_end_date,hr_general.end_of_time,''A'',''I'') status,
958: hours,
959: element_type_id,
960: pay_status,
961: pbl_line_id,

Line 2431: AND sum.effective_end_date < hr_general.end_of_time

2427: AND det.pay_status = 'B'
2428: AND det.parent_id = sum.id
2429: AND sum.effective_start_date <= det.effective_start_date
2430: AND sum.effective_end_date >= det.effective_end_date
2431: AND sum.effective_end_date < hr_general.end_of_time
2432: AND sum.time_building_block_id = ret.time_building_block_id
2433: AND sum.time_building_block_ovn = ret.old_ovn
2434: AND det.retro_pbl_line_id = ret.retro_pbl_id
2435: AND ret.retro_batch_id = pbl.batch_id;

Line 2455: AND sum.effective_end_date = hr_general.end_of_time

2451: AND det.tim_id = p_tim_id
2452: AND det.parent_id = sum.id
2453: AND sum.effective_start_date <= det.effective_start_date
2454: AND sum.effective_end_date >= det.effective_end_date
2455: AND sum.effective_end_date = hr_general.end_of_time
2456: AND sum.time_building_block_id = ret.time_building_block_id
2457: AND sum.time_building_block_ovn = ret.object_version_number
2458: AND det.retro_pbl_line_id = ret.retro_pbl_id
2459: AND ret.retro_batch_id = pbl.batch_id;

Line 3110: AND effective_end_date = hr_general.end_of_time

3106: -- Added 'R' in the IN list.
3107: UPDATE hxt_det_hours_worked_f
3108: SET effective_end_date = SYSDATE -1
3109: WHERE tim_id = p_tim_id
3110: AND effective_end_date = hr_general.end_of_time
3111: AND pay_status IN ('A','B','D','R');
3112:
3113: -- Bug 13777315
3114: UPDATE hxt_det_hours_worked_f

Line 3117: AND effective_end_date <> hr_general.end_of_time

3113: -- Bug 13777315
3114: UPDATE hxt_det_hours_worked_f
3115: SET pay_status = 'Z'
3116: WHERE tim_id = p_tim_id
3117: AND effective_end_date <> hr_general.end_of_time
3118: AND pay_status = 'C';
3119:
3120: UPDATE hxt_det_hours_worked_f
3121: SET effective_end_date = SYSDATE -1,

Line 3124: AND effective_end_date = hr_general.end_of_time

3120: UPDATE hxt_det_hours_worked_f
3121: SET effective_end_date = SYSDATE -1,
3122: pay_status = 'Z'
3123: WHERE tim_id = p_tim_id
3124: AND effective_end_date = hr_general.end_of_time
3125: AND pay_status = 'C';
3126:
3127: UPDATE hxt_det_hours_worked_f
3128: SET rollback_status = 'R'