APPS.PAY_GB_ROLLBACK dependencies on PAY_GB_FPS_DETAILS

Line 22: in PAY_GB_FPS_DETAILS table.

18: Assignment and View Payroll Process Results forms.
19: 13-Sep-2012 krreddy 115.2 14553830 Removed the GB_ROLLBACK procedure and
20: moved it into PAY_GB_ROLLBACK_PKG.
21: 02-Nov-2012 ssarap 115.3 For NI only aggregation deleting the orphan data
22: in PAY_GB_FPS_DETAILS table.
23: 02-Nov-2012 kvinayku 115.4 14843731 Added one more condition to reset pensioner RTI sent flag.
24: 28-Dec-2012 sampamnd 115.5 14759083 Added procedures for rollback related cahnges for EAS and EAS 13.
25: =============================================================================*/
26: --

Line 162: -- Delete from pay_gb_fps_details

158: IF l_ovn IS NOT NULL THEN
159: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
160: END IF;
161: END IF;
162: -- Delete from pay_gb_fps_details
163: DELETE
164: FROM pay_gb_fps_details
165: WHERE FPS_ASG_ACT_ID = archive_rec.ASSIGNMENT_ACTION_ID
166: AND ASSIGNMENT_ID = archive_rec.ASSIGNMENT_ID;

Line 164: FROM pay_gb_fps_details

160: END IF;
161: END IF;
162: -- Delete from pay_gb_fps_details
163: DELETE
164: FROM pay_gb_fps_details
165: WHERE FPS_ASG_ACT_ID = archive_rec.ASSIGNMENT_ACTION_ID
166: AND ASSIGNMENT_ID = archive_rec.ASSIGNMENT_ID;
167: END LOOP;
168: FOR del_rec IN csr_get_all_actions

Line 170: -- Delete from pay_gb_fps_details

166: AND ASSIGNMENT_ID = archive_rec.ASSIGNMENT_ID;
167: END LOOP;
168: FOR del_rec IN csr_get_all_actions
169: loop
170: -- Delete from pay_gb_fps_details
171: DELETE
172: FROM pay_gb_fps_details
173: WHERE FPS_ASG_ACT_ID = del_rec.ASSIGNMENT_ACTION_ID
174: AND ASSIGNMENT_ID = del_rec.ASSIGNMENT_ID;

Line 172: FROM pay_gb_fps_details

168: FOR del_rec IN csr_get_all_actions
169: loop
170: -- Delete from pay_gb_fps_details
171: DELETE
172: FROM pay_gb_fps_details
173: WHERE FPS_ASG_ACT_ID = del_rec.ASSIGNMENT_ACTION_ID
174: AND ASSIGNMENT_ID = del_rec.ASSIGNMENT_ID;
175: end loop;
176: ELSE -- for IF (p_asgactid is null) THEN condition

Line 208: -- Delete from pay_gb_fps_details

204: IF l_ovn IS NOT NULL THEN
205: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS', p_aei_information8 => 'N');
206: END IF;
207: END IF;
208: -- Delete from pay_gb_fps_details
209: DELETE
210: FROM pay_gb_fps_details
211: WHERE FPS_ASG_ACT_ID = l_asgact_rec.ASSIGNMENT_ACTION_ID
212: AND ASSIGNMENT_ID = l_asgact_rec.ASSIGNMENT_ID;

Line 210: FROM pay_gb_fps_details

206: END IF;
207: END IF;
208: -- Delete from pay_gb_fps_details
209: DELETE
210: FROM pay_gb_fps_details
211: WHERE FPS_ASG_ACT_ID = l_asgact_rec.ASSIGNMENT_ACTION_ID
212: AND ASSIGNMENT_ID = l_asgact_rec.ASSIGNMENT_ID;
213: CLOSE csr_archive_asgact_details;
214: