APPS.PAY_GB_FPS_NI_AND_OTHERS dependencies on PAY_GB_FPS_DETAILS

Line 3583: -- Delete from pay_gb_fps_details

3579: IF l_ovn IS NOT NULL THEN
3580: 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');
3581: END IF;
3582: END IF;
3583: -- Delete from pay_gb_fps_details
3584: DELETE
3585: FROM pay_gb_fps_details
3586: WHERE FPS_ASG_ACT_ID = archive_rec.ASSIGNMENT_ACTION_ID
3587: AND ASSIGNMENT_ID =archive_rec.ASSIGNMENT_ID;

Line 3585: FROM pay_gb_fps_details

3581: END IF;
3582: END IF;
3583: -- Delete from pay_gb_fps_details
3584: DELETE
3585: FROM pay_gb_fps_details
3586: WHERE FPS_ASG_ACT_ID = archive_rec.ASSIGNMENT_ACTION_ID
3587: AND ASSIGNMENT_ID =archive_rec.ASSIGNMENT_ID;
3588: END LOOP;
3589: END;