APPS.PER_IE_TERMINATION dependencies on PAY_IE_PRSI_DETAILS_F

Line 89: FROM pay_ie_prsi_details_f

85: CURSOR c_get_prsi_details(
86: p_assignment_id per_all_assignments_f.assignment_id%TYPE)
87: IS
88: SELECT prsi_details_id, effective_start_date, effective_end_date
89: FROM pay_ie_prsi_details_f
90: WHERE assignment_id = p_assignment_id AND
91: p_final_process_date BETWEEN effective_start_date
92: AND effective_end_date
93: ORDER BY effective_start_date;

Line 100: l_prsi_detail_id pay_ie_prsi_details_f.prsi_details_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---------
104: BEGIN

Line 101: l_prsi_start_date pay_ie_prsi_details_f.effective_start_date%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---------
104: BEGIN
105:

Line 102: l_prsi_end_date pay_ie_prsi_details_f.effective_end_date%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---------
104: BEGIN
105:
106:

Line 136: UPDATE pay_ie_prsi_details_f

132: FETCH c_get_prsi_details INTO l_prsi_detail_id,
133: l_prsi_start_date,
134: l_prsi_end_date;
135:
136: UPDATE pay_ie_prsi_details_f
137: SET effective_end_date = p_final_process_date
138: WHERE prsi_details_id = l_prsi_detail_id AND
139: p_final_process_date BETWEEN effective_start_date
140: AND effective_end_date;

Line 142: DELETE FROM pay_ie_prsi_details_f

138: WHERE prsi_details_id = l_prsi_detail_id AND
139: p_final_process_date BETWEEN effective_start_date
140: AND effective_end_date;
141:
142: DELETE FROM pay_ie_prsi_details_f
143: WHERE prsi_details_id = l_prsi_detail_id AND
144: effective_start_date > p_final_process_date;
145:
146: CLOSE c_get_prsi_details;

Line 214: UPDATE pay_ie_prsi_details_f

210: WHERE assignment_id = asg_id.assignment_id AND
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;