APPS.PER_IE_TERMINATION dependencies on HR_GENERAL

Line 209: SET effective_end_date = TO_CHAR(hr_general.end_of_time, 'DD-MON-YYYY')

205: CLOSE csr_final_process_date;
206: hr_utility.trace('l_final_process_date' || to_char(l_final_process_date));
207: --
208: UPDATE pay_ie_paye_details_f
209: SET effective_end_date = TO_CHAR(hr_general.end_of_time, 'DD-MON-YYYY')
210: WHERE assignment_id = asg_id.assignment_id AND
211: l_final_process_date BETWEEN effective_start_date
212: AND effective_end_date;
213:

Line 215: SET effective_end_date = TO_CHAR(hr_general.end_of_time, 'DD-MON-YYYY')

211: l_final_process_date BETWEEN effective_start_date
212: AND effective_end_date;
213:
214: UPDATE pay_ie_prsi_details_f
215: SET effective_end_date = TO_CHAR(hr_general.end_of_time, 'DD-MON-YYYY')
216: WHERE assignment_id = asg_id.assignment_id AND
217: l_final_process_date BETWEEN effective_start_date
218: AND effective_end_date;
219: End loop;