APPS.PER_IE_TERMINATION dependencies on PAY_IE_PAYE_DETAILS_F

Line 78: FROM pay_ie_paye_details_f

74: IS
75: SELECT paye_details_id,
76: effective_start_date,
77: effective_end_date
78: FROM pay_ie_paye_details_f
79: WHERE assignment_id = p_assignment_id AND
80: p_final_process_date BETWEEN effective_start_date
81: AND effective_end_date
82: ORDER BY effective_start_date;

Line 97: l_paye_detail_id pay_ie_paye_details_f.paye_details_id%TYPE;

93: ORDER BY effective_start_date;
94: --Local vriables-----
95: l_person_id per_periods_of_service.person_id%TYPE;
96: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;
97: l_paye_detail_id pay_ie_paye_details_f.paye_details_id%TYPE;
98: l_paye_start_date pay_ie_paye_details_f.effective_start_date%TYPE;
99: l_paye_end_date pay_ie_paye_details_f.effective_end_date%TYPE;
100: l_prsi_detail_id pay_ie_prsi_details_f.prsi_details_id%TYPE;
101: l_prsi_start_date pay_ie_prsi_details_f.effective_start_date%TYPE;

Line 98: l_paye_start_date pay_ie_paye_details_f.effective_start_date%TYPE;

94: --Local vriables-----
95: l_person_id per_periods_of_service.person_id%TYPE;
96: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;
97: l_paye_detail_id pay_ie_paye_details_f.paye_details_id%TYPE;
98: l_paye_start_date pay_ie_paye_details_f.effective_start_date%TYPE;
99: l_paye_end_date pay_ie_paye_details_f.effective_end_date%TYPE;
100: l_prsi_detail_id pay_ie_prsi_details_f.prsi_details_id%TYPE;
101: l_prsi_start_date pay_ie_prsi_details_f.effective_start_date%TYPE;
102: l_prsi_end_date pay_ie_prsi_details_f.effective_end_date%TYPE;

Line 99: l_paye_end_date pay_ie_paye_details_f.effective_end_date%TYPE;

95: l_person_id per_periods_of_service.person_id%TYPE;
96: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;
97: l_paye_detail_id pay_ie_paye_details_f.paye_details_id%TYPE;
98: l_paye_start_date pay_ie_paye_details_f.effective_start_date%TYPE;
99: l_paye_end_date pay_ie_paye_details_f.effective_end_date%TYPE;
100: l_prsi_detail_id pay_ie_prsi_details_f.prsi_details_id%TYPE;
101: l_prsi_start_date pay_ie_prsi_details_f.effective_start_date%TYPE;
102: l_prsi_end_date pay_ie_prsi_details_f.effective_end_date%TYPE;
103: --end Local vriables---------

Line 152: UPDATE pay_ie_paye_details_f

148: OPEN c_get_paye_details(asg_id.assignment_id);
149: FETCH c_get_paye_details INTO l_paye_detail_id,
150: l_paye_start_date,
151: l_paye_end_date;
152: UPDATE pay_ie_paye_details_f
153: SET effective_end_date = p_final_process_date
154: WHERE paye_details_id = l_paye_detail_id AND
155: p_final_process_date BETWEEN effective_start_date
156: AND effective_end_date;

Line 157: DELETE FROM pay_ie_paye_details_f

153: SET effective_end_date = p_final_process_date
154: WHERE paye_details_id = l_paye_detail_id AND
155: p_final_process_date BETWEEN effective_start_date
156: AND effective_end_date;
157: DELETE FROM pay_ie_paye_details_f
158: WHERE paye_details_id = l_paye_detail_id AND
159: effective_start_date > p_final_process_date;
160: CLOSE c_get_paye_details;
161: hr_utility.set_location(

Line 186: FROM pay_ie_paye_details_f

182:
183: CURSOR csr_final_process_date(p_assignment_id Number)
184: IS
185: SELECT max(effective_end_date)
186: FROM pay_ie_paye_details_f
187: WHERE assignment_id = p_assignment_id;
188: --
189: BEGIN
190: hr_utility.trace('Inside reverse term');

Line 208: UPDATE pay_ie_paye_details_f

204: FETCH csr_final_process_date INTO l_final_process_date;
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;