APPS.PAY_GB_FPS_NI_AND_OTHERS_13 dependencies on PAY_GB_FPS_DETAILS

Line 3578: -- Delete from pay_gb_fps_details

3574: IF l_ovn IS NOT NULL THEN
3575: 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');
3576: END IF;
3577: END IF;
3578: -- Delete from pay_gb_fps_details
3579: DELETE
3580: FROM pay_gb_fps_details
3581: WHERE FPS_ASG_ACT_ID = archive_rec.ASSIGNMENT_ACTION_ID
3582: AND ASSIGNMENT_ID =archive_rec.ASSIGNMENT_ID;

Line 3580: FROM pay_gb_fps_details

3576: END IF;
3577: END IF;
3578: -- Delete from pay_gb_fps_details
3579: DELETE
3580: FROM pay_gb_fps_details
3581: WHERE FPS_ASG_ACT_ID = archive_rec.ASSIGNMENT_ACTION_ID
3582: AND ASSIGNMENT_ID =archive_rec.ASSIGNMENT_ID;
3583: END LOOP;
3584: END;